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.
N44886Personal Aviation Inc · Poway, CAN44887Gabriel Robert A · Lancaster, PAN4488RSmith Byron L · Bourbon, INN4488SMartens Paul A · Fairview, OKN4488TN4488t LLC · Newport Beach, CAN4488XReklis Aviation LLC · Schaumburg, ILN4488ZAlaska Tailwheel LLC · Fairbanks, AKN4489Golden Age Air Museum · Bethel, PAN44898Andel Robert M · Milford, CTN4489PTj 2 LLC · Jackson, MIN4489SBeaufort Capital Partners LLC · Winston Salem, NCN4489WHogan Johnny R · Overbrook, OKN4489XFidelis Aviation LLC · Cornelius, NCN4489ZHernandez Michael J · Sterling, AKN448AKN448ak LLC · Helena, MTN448ALWheeler Alexa L · Tavernier, FLN448BASpitzer Helicopter LLC · Woodland Hills, CAN448BBHawkflight LLC · Sugar Land, TXN448BLBlue Line Aviation LLC · Smithfield, NCN448CGTurville Gay Ann · Austin, TXN448CPCivil Air Patrol · Maxwell Afb, ALN448DDillingham John E · Enid, OKN448DBC V C Holdings LLC · Pasco, WAN448ERAtp Aircraft 4 LLC · Wilmington, DEN448ESSchaefer Mark D · Oconomowoc, WIN448HWCentral Oregon Aviation Services LLC · Bend, ORN448JDavenport James A · San Antonio, TXN448JAGood Flight Aviation LLC · Stockton, CAN448KGTondi David M · Sterling, VAN448LAircraft Management Corp · Wilmington, DEN448MCToczek Keith E · Yankton, SDN448MJWilson Darrell Gene III · Mcpherson, KSN448MKNorth Star Aviation · Mankato, MNN448MMCummins Zachariah T · Portland, ORN448RBBlenden Robert E · Oviedo, FLN448RJRonald Janis · New York, NYN448RMPiper Aircraft Inc · Vero Beach, FLN448RVMccarley James M · Gatesville, TXN448SHNovember Alpha LLC · Los Angeles, CAN448SPWilliams Donald B · Sharps Chapel, TNN448SRAquatic Resources Management LLC · Lexington, KYN448VQBabcock Rowland A · Ruther Glen, VAN448ZAlpha Tango Aircraft LLC · Wilmington, DEN449Destroyla Inc · Los Angeles, CAN4490ASmith Jeffrey Steven · Fenton, MIN4490JAmes Bradley · Bushland, TXN4490PWelke Aviation Inc · St James, MIN4490WFrisch Josef C · Belmont, CAN4490YMinnesota Soaring Club Inc · Stanton, MNN44929Registered aircraft
Back to AD 2007-04-19 R1