AD 2007-04-19 R1
Registered aircraft · 108,434
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N4359YSportsman Airpark Inc · Newberg, ORN4359ZBritton Kelly D · Buffalo, SDN435CAWingsleasing LLC · Wichita, KSN435CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYN435DBHigh Velocity Design Inc · Ferndale, MIN435DEThunderbird Aero LLC · Mertzon, TXN435GSStott Glenn G · Matawan, NJN435JMBonanza A36 LLC · Nashville, TNN435KRHaug William C Trustee · Reno, NVN435MGonzalez Frank · Sun Valley, CAN435MCSmoketown Flight Center LLC · Smoketown, PAN435NDPars Avn Corp · Wilmington, DEFirst renewal noticeN435PABird Acquisition LLC · Phoenix, AZN435RMBryant Lyle W · Ellinwood, KSN435RTBloom Mark W · Miami, FLN435SPBoeing Employees Flying Association · Renton, WAN435TAPanther Med LLC · Derby, KSN435XBorders Nowell · Edinburg, TXN43601Sale Reported · Green Valley, AZSale reportedN43604Indian Valley Aero LLC · Telford, PAN4360CBckm LLC · Florida, NYN4360JDonaldson Gary K · Kearns, UTN4360QStoll Paul C · Blossom, TXN4360RGrasshopper Flying Club Inc · Poughkeepsie, NYN4360VMb Powers Inc · Thompsons Station, TNN4360ZPetersen Jacob R · Wasilla, AKN4361ARust Todd S · Anchorage, AKN4361HSazhin Michael · Brooklyn, NYN4361JRever David L · Laurel, MDN4361MCape May Aerial Advertising LLC · Cape May Ch, NJN4361RElkhorn Aviation Inc · Baker City, ORN4361VJenkins Justin Lee · Minot, NDN4361XCharles City Aeronautics Inc · Charles City, IAN4361ZBennett Scott M · Ninilchik, AKN43621Weade Ronald J · Wshngtn Ct Hs, OHN43625Southern Colorado Flight Professionals LLC · Pueblo, CON43627Crawford Tommi Regina · Branson, MON4362DBrinkerhoff Jeffrey C · Auburn, NYN4362QQuacker Holdings LLC · Aspen, CON4362RBruther Thomas J · Temecula, CAN4362WReaume Andrew G · Wayne, PAN4362XSiegel Kurt · Denver, NCN4362YBarrett Jane T · Tehachapi, CAN4362ZCooper Scott J · Fellows, CAN43632Tfc Inc · Somers, CTN43633Rambo Lawrence E · Eatonton, GAN43636Hughes Robert W · Lomita, CAN4363ASchulz Florian · Anchorage, AKN4363DRaf Aircraft Pilot Services LLC · Wilmington, DEN4363JWoeste Joseph R · Sauk Centre, MN
Back to AD 2007-04-19 R1