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.
N44997Faulkner 44 LLC · Wilmington, DEN4499JWiblemo Craig B · Fallbrook, CAN4499PTls Aviation · Marysville, WAN4499WUrban James R · Pierre, SDN449AArcher Aero LLC · Wilmington, DEN449AGKershner Jordan · Malcolm, NEN449AK3 Danes And A Moose LLC · Granada Hills, CAN449ASConcho Aviation LLC · Sterling City, TXN449BASpitzer Helicopter LLC · Woodland Hills, CAN449BCMcbride Richard A · Deer Park, WAFirst renewal noticeN449BLBlue Line Aviation LLC · Smithfield, NCN449CD9 Robin LLC · Wilmington, DEN449CNSpeedo Air LLC · Hales Location, NHN449CSHorizon Flight Center LLC · Chesapeake, VAN449DAArford Dennis C · Athens, GAN449DMMccord David B · Chico, CAN449EWWilliams Ethan B Trustee · Wasilla, AKN449FAAlba Aviation Services Inc · Scottsdale, AZN449JGHerlihy John J · Arroyo Grande, CAN449LMontana Hotel LLC · Providence, UTN449LLPlane Fun Inc Tr Trustee · Snellville, GAN449MKNorth Star Aviation · Mankato, MNN449MSMs Aviation LLC · Los Angeles, CAN449PAChristiansen Aviation LLC · Wilmington, DEN449PMMullenbach Michael R · Saint Ansgar, IAN449PSMid Atlanta Air Museum · Reading, PAN449RV T Whitlock Inc · Lake City, SCN449RMRocky Mountain College · Billings, MTN449RVRobinson Stewart · San Jacinto, CAN449SFKyle Allyn B · Snohomish, WAN449SPGolden Eagle Flying Club Ltd · West Islip, NYN449TSmallwood David · Oak Ridge, TNN449VYKirkham Matthew · Cazenovia, WIN449WFGlenns Super Cub LLC · Fort Lauderdale, FLN44ARounds Don DBA · Waller, TXN44ABAnthony Ronald W · Claremont, CAN44ADTice Logan Edward · Noblesville, INN44AGVanderpool Gary W · Alamo, TXN44AKAvcom Co · Friday Harbor, WAN44AYPartin Kathy L · Nacogdoches, TXN44BKBirum Kevin M · Kingston, WAN44BLBoehr Greg J · Mc Cool Junction, NEN44BPAircraft Partner Holdings Inc Trustee · BerlinN44BWMariani Aviation Services LLC · Vero Beach, FLN44CCoyne Greg · Hondo, TXN44CAWiley Commercial Property Consulting Inc · Aitkin, MNN44CCColumbia Club Aero LLC · East Wenatchee, WAN44CFFly Low Aviation LLC · Smithville, MSN44CMRussell Stephen J · Chester, VTN44CUAirstar Aviation LLC · Manawa, WI
Back to AD 2007-04-19 R1