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.
N5127GKurtz Joseph A · Hamilton, GAN5127HSmith Dan R · Montrose, SDN5127NSierra Breeze LLC · Springfield, MON5127QRegistered aircraftN5127RAmerican Industrial Laundry · Lander, WYN5127SWeston Thomas J · Stratford, NJN5127UFowler Ron W · Lopez Island, WAN5127VGriffy Paige E · Decatur, ILN5127YAirborne Extreme LLC · Wasilla, AKN5127ZPohland Charles A · Anchorage, AKN51282Registration Pending · West Point, NERegistration pendingN5128BEastman Gregory L · Pueblo, CON5128CLacey Nora B Trustee · Incline Village, NVN5128DKingsky Flight Academy LLC · Lakeland, FLN5128EButt Thomas P · Whitt, TXN5128GSale Reported · Gainesville, FLSale reported, pending cancellationN5128HWelsh Rolland R · Shady Shores, TXN5128LSquawk 2017 LLC · Flowery Branch, GAN5128PSchafer David · Northport, ALN5128RBend Aircraft Mechanics LLC · Bend, ORN5128SDonegan Martin A O · Bethlehem, PAN5128VBeulen Brian V · Mesa, AZN51295Right Brother Aviation LLC · Chaffee, NYN51297Ingram Dale D · Klamath Falls, ORN5129DPolatis Daniel T · Pingree, IDN5129ETjr Aviation LLC · Orefield, PAN5129QWaters John E · Renton, WAN5129SSplendid Aviation Inc · Corpus Christi, TXN5129VBirdzell Luther E · Hood River, ORN5129WStanek Kenneth W Jr · Russellville, ARN5129XSmall Aviation No 2 LLC · Villa Rica, GAN5129YCarter Ronald Lynn · Nenana, AKN512ACBuck James Kyle III · Oak Ridge, NCN512AFAmeriflyers Of Texas Inc · Addison, TXN512ATRanch Aero LLC · Sterling City, TXN512BLawler Glenn M · Mooresville, NCN512BDTurbo Aviation LLC · Chesterfield, SCN512BWMontauk Catamaran Co LLC · Montauk, NYN512CDRns Management Holdings LLC · Naples, FLN512CTCoast Flight Training And Management Inc · San Diego, CAN512FLReiley Allen Ted · Lavernia, TXN512GTBarron Thomas Aviation Inc · Scottsdale, AZN512HPN512hp LLC · Dover, DEN512JGJacobs Gareth · Woodruff, SCN512JHHenson David · Fallon, NVN512JSSutton James · Clinton, NCN512KZotec Partners LLC · Carmel, INN512KCJunfer Flyers LLC · Wilmington, DEN512KMWhite Holdings LLC · Washington, INN512KWDown Three Green LLC · Liberty, TN
Back to AD 2007-04-19 R1