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.
N35732Minney Andrew · Memphis, TNN35735Gaston Brothers Excavating Inc · Seattle, WAN35738Plane Life LLC · Wilmington, DEN3573FLutke Michael T · Kalamazoo, MIN3573GDuran Robert J · Fort Lupton, CON3573HBarnes Terry A · Austin, TXN3573PStewart James B · Anchorage, AKN3573QFly Lugu LLC · Westfield, MAN3573UHigginson James E · Bellingham, WAN3573WRay Blake · Midland, TXN3573YDesantis Robert George · Tavernier, FLN3573ZBlue Ice Aviation Inc · Wasilla, AKN35741Covelli Scott · Spicewood, TXN35744Noland Farms Inc · Blue Mound, ILN35746Hoard David L · Germantown, TNN35748Price Stanley C · Grapevine, TXN35749Pashley John F · Johnstown, NYN3574CAtd Pilot Training LLC · Kansas City, MON3574JI.F.C. Inc · Wayne, NEN3574RGarner Financial Management Inc · Franklin, TNN3574URegistered aircraftN3574ZWestwood Dave · Red Lodge, MTN35751Bas Part Sales LLC · Greeley, CON35752Radcliffe Ronald W · Juneau, AKN35753Gipson Aviation LLC · Beach City, TXN35755Varin Joseph J · Smithfield, RIN3575AScoval Aviation LLC · Murray, KYN3575KN83993 LLC · Cherry Hill, NJN3575LSwann Robert A · Hereford, AZN3575NPierson Oran · Tucson, AZN3575UJ P Aviation LLC · Kingfisher, OKN3575XSmith Foster Fritz · Bishopville, SCN3575YMeyer Robert J · Davis, CAN3575ZRieke Rhett W · Bigfork, MTN35760Johnson Harry D Jr · Unalakleet, AKN35762Aerial Sign North Inc · Lakewood, NJN35763Woodson Marcus S · Waxahachie, TXN3576HJohnson Grant J · Doylestown, PAN3576JStephens Lloyd G · Saratoga, CAN3576MFly Legacy Planes LLC · Philadelphia, PAN3576RDuffys Aircraft Sales & Leasing Inc · Neillsville, WIN3576UBinse Gerald R · Yuba City, CAN3576WEllison David L · Stockbridge, GAN3576YHmh Consolidated LLC · Lake Placid, FLN35770Ccb Flyers LLC · Waco, TXN35779Syrang Aero Club Inc · Cato, NYFirst renewal noticeN3577PKeegan Stephen E III · Nome, AKN3577QSousa Joao P · Prince Frederick, MDN3577YClifton Oil & Gas LLC · Millville, DEN35788Glennon Christopher M · Villa Park, IL
Back to AD 2007-04-19 R1