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.
N4764URegistered aircraftN4764YOk3wire Properties LLC · Pensacola, FLN4765Rock Kevin M · Ashland, NEN47651Paris Air Inc · Vero Beach, FLN47653Fat Chance Airlines LLC · Hillsville, VAN47656Adventure North Flying Service LLC · Aitkin, MNFirst renewal noticeN47657Dallam Pat M · Cool, CAN4765GAircraft Charter And Leasing LLC · El Cerrito, CAN4765JHall Jarrod L · Eufaula, OKN4765LClements Corbin B · Snyder, TXN4765QDigger Dougs Crop Dusting Services Inc · Salem, WIN47660Edwards Mikiko S · Hoover, ALN47661Wopuna And Son LLC · Vancouver, WAN47669Registered aircraftN4766DHutchison Frank J · Tucson, AZN4766EWillard Raymond C · Wasilla, AKN4766FPrairie Fox Aviation LLC · Olathe, KSN4766HHay Christopher C · Sweet Home, ORN4766MFx5 Construction & Excavation Inc · Decatur, TXN4766UMoore Murray H · Twain Harte, CAN4767Southern Aircraft Consultancy Inc Trustee · Casper, WYN47673Falcon View Aviation LLC · Mckinney, TXN47674Sides Blake A · Jackson, TNN47675Czeck Steven S · New Hope, PAN47676Wulfekuhler Louis E · Lansing, MIN4767DFulton Daniel M · Blacksburg, SCN4767NDavid Bell Farms Inc. Po Box 160 · Beaverton, ORN4767UDeckload Aviation LLC · Kodiak, AKN47680New Mexico Flying Eagle DBA · Tucson, AZN47687Acevedo Gabriel Jr · Rego Park, NYN4768BEversole Eric L · Kent, WAN4768DBoyd Amy L · Kila, MTN4768EEagle Aviation Inc · Tucson, AZN4768FZankiz Jose Carlos · Naples, FLN4768KJohnson Durwood · Beaumont, TXN4768NTreadwell Dennis A · El Cajon, CAN4768PBoone Patrick J · San Antonio, TXN4768SDidier Thomas · Port Washington, WIN47693Denton Max L · Marion, OHN47694Aircraft Owners And Pilots Assn · Frederick, MDN47697Andrews Dana C · Granite Bay, CAN47698Mcgregor Daniel A · Denali Park, AKN47699Swinney Audie G · Henryetta, OKN4769ANewbury Terry A · Florence, ALN4769BNesbett David A Trustee · Anchorage, AKN4769GMagnumforamen Ppg Aero Adventures LLC · Kalispell, MTN4769KSpirit 210 LLC · Missoula, MTN4769LTurn 2 Aviation LLC · Bloomsburg, PAN4769NTurner Luke · Mineral Wells, TXN4769SRedemption Leasing LLC · Kodiak, AK
Back to AD 2007-04-19 R1