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.
N540MDPlane Fun Inc Tr Trustee · Snellville, GAN540MGLevin Robert A · Elkins Park, PAN540MMJohnson Barry · Roanoke, ALN540MPDukes Jeff A · Cape Coral, FLN540MRGrinstead Holdings LLC · Cincinnati, OHN540MXSouthern Aircraft Consultancy Inc Trustee · Casper, WYN540NDAerosim Academy Inc · Sanford, FLN540NEAirswiss Inc · Wilmington, DEN540PSOlerud Erik · Dulles, VAN540PULeo S Anton · Aliso Viejo, CAN540RLache Benjamin Isaac · Port Orange, FLN540RBEhrich Kevin J · New Braunfels, TXN540RCHuffstutler Stephen C · Uvalde, TXN540RFRussell William L · Washington, INN540RMMokry Robert B · San Francisco, CAN540RROrr David A C · Lake Forest, CAN540RSLee Ric A · Sandy, UTN540SBAusbrooks Benjamin P · Meridian, MSN540SCMorton Michael E · Hickory, NCN540SESoar International LLC · Olive Branch, MSN540SGBurns Melissa · Talkeetna, AKN540SSCode Supplies Inc · Rossville, TNN540SWSolberg Scott E · Comfort, TXN540TAMontana Aircraft Trust Inc Trustee · Bozeman, MTN540TCRoss Shannon M · Boise, IDN540TDFitzgerald Craig A · Collinsville, OKN540TMRegistered aircraftN540TR222 Aviation LLC · Oakhurst, CAN540TXBoho LLC · Lewes, DEN540UBoard Of Regents Of The University Of Oklahoma · Norman, OKN540VLLuker Victor R Jr · Terrell, TXN540WSOlerud Erik · Dulles, VAN540WTTurner Mark D · Roseville, CAN540WWWischer Neil O · Davenport, WAN540XCampbell Scott A · Marseilles, ILN540XSSouthern Aircraft Consultancy Inc Trustee · Casper, WYN540XXRegistration Pending · Kingman, AZRegistration pendingN54100Pilot Aeromedical Consulting Services LLC · Freeland, MIN54102Adriatic Holdings LLC · Cheyenne, WYN54105Gopub Aviation Inc Trustee · Wilmington, DEN54107Duininck James R · Willmar, MNN54108Lawson Troy · Kettle Falls, WAN5410BOklahoma Soaring Association · Mustang, OKN5410HMeggers Roger D · Baker, MTN5410UN5410u LLC · West Babylon, NYN5410YFoxtrot Air LLC · Highmore, SDN54115Mang Aero Club Inc · Belleville, MIN5411AMarc Aircraft Holding LLC · Soldotna, AKN5411BBailey Carl D · Huntington, WVN5411DFellows David O · Mc Alpin, FL
Back to AD 2007-04-19 R1