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.
N570HRegistered aircraftN570JAJ A Flight Services LLC · Sugar Grove, ILN570JSRust James P · Seymour, INN570MATuminello Joseph A · San Francisco, CAN570MTMiddle Tennessee State University · Murfreesboro, TNN570NDAerosim Academy Inc · Sanford, FLN570PUPurdue University Trustees · West Lafayette, INN570RVBell Arthur M · Parkville, MDN570SRobinson Michael D · Folkston, GAN570SCSpartan Education LLC · Tulsa, OKN570SPOne Seventy To Delta LLC · Scottsdale, AZN570TWilcox Robbie Craig · Smithville, MON570TCCook Timothy · Byrdstown, TNN570TFAir Fleet Holdings LLC · Missoula, MTN570UOhio University · Albany, OHN570WHMf Helicopters LLC · East Troy, WIN5710BNampa Aviation Holdings LLC · Boise, IDN5710FOso Air LLC · Missoula, MTN5710QHopper Ronald W · Thousand Oaks, CAN5710VOdell Stephen H · Thousand Oaks, CAN5710WOso Air LLC · Missoula, MTN5711BVtoss Holdings LLC · Anchorage, AKN5711DEastin Toby M · Jefferson City, MON5711FVoelker Steve L · Clackamas, ORN5711MSwager Joel P · Ione, CAN5711UBlack Cat Aviation Inc · Wilmington, DEN5711VBrack-Ponce Annabelle S · Zephyr Cove, NVN5712DLo Jeffrey G · San Jose, CAN5712FPhil Birkelbach · Waller, TXN5712JFree Air LLC · Helena, MTN5712MDay Star Aviation Inc · Locust Grove, GAN5712PGibson Kevin M · Denver City, TXN5712QChambliss Walton Aviation Enterprises LLC · Greer, SCN5712UPark Hui Nam · Buena Park, CAN57133Grove Ronald DBA · San Carlos, CAN5713FDufresne Justin B · San Tan Valley, AZN5713KJennings James H · Clovis, NMN5713VCaribbean Dental Lab LLC · St Thomas, VIN5714DAnte George Sherman Jr · Eagle River, AKN5714FRegistration Pending · Arlington, TXRegistration pendingN5714KHonour Aviation LLC · Merritt Island, FLN5714UTxl Consulting LLC · Hurst, TXN5715DScootair LLC · Alburgh, VTN5715KChase Brandon C · Plains, KSN5715MExpress Air LLC · Wilmington, DEN5715RBingham David · Marked Tree, ARN5715WRyan Peter C · Riverhead, NYN5716BHare Alison S P Trustee · Grass Valley, CAN5716DNeumayer Barry A · Redlands, CAN5716QEdick Thomas M · Wasco, CA
Back to AD 2007-04-19 R1