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.
N5059DJk Aviations LLC · Yardley, PAN5059KLucia Keith G · Pleasant Hill, CAN5059LAeromarine Airways Corp · Miami, FLN5059PVertical Edge Enterprises LLC · Chandler, AZN5059TGimenez Roberto Jorge · Merritt Island, FLN5059WSmith Michael L · Satellite Beach, FLN505ABFredrickson Kenneth · Port Angeles, WAN505AFAmeriflyers Of Texas Inc · Addison, TXN505ATGraupman Gerald · Chicago, ILN505BJLa Beau Lawrence O · San Angelo, TXN505CSparrowhawk Aviation · Manvel, TXN505CDValiair Limited Company Owner Trustee · Casper, WYN505CEMoore Travis S · Montrose, CON505CK7l Ranch Operations LLC · Pyote, TXN505CMStout Walter J · White Hills, AZN505CNLes Amis Air LLC · Dorado, PRN505CPCivil Air Patrol · Maxwell Afb, ALN505EGShamrock Aviation Resources LLC · Paulden, AZN505EPSuper 21 LLC · Litchfield Park, AZN505FLComer Christopher C · Randleman, NCN505GAlford Robert S · Columbus, GARegistration revokedN505GSVolar Corp · El Cajon, CAN505HSHolt Helicopters Inc · Uvalde, TXN505JFRegistered aircraftN505JPRbh LLC · Lagrange, GAN505JRParker Matthew · Cloudcroft, NMN505KBBrowder Mark E · Charlotte, NCN505LShores Robert C · Rocklin, CAN505LMKennicott Wilderness Air LLC · Glennallen, AKN505LPWifa (Washington International Flight Academy) LLC · Gaithersburg, MDN505MRVance Thomas E · Riverhead, NYN505PDSargent Evan · Camas, WAN505PPOnionaire LLC · Aurora, ILN505PTBeckett Consulting Services Inc · Fort Collins, CON505SACsi Aviation Inc · Albuquerque, NMN505SBCuadra Joanne S · Houston, TXN505SCSpartan Education LLC · Tulsa, OKN505SFLux William E · Newman Lake, WAN505SWBas Part Sales LLC · Greeley, CON505TRCaralex Aviation LLC · Mcallen, TXN505TTWebber James F · Arvin, CAN505UAlba Leasing Services LLC · Scottsdale, AZN505VCRoe Robert M · Pearland, TXN505WCQualitair LLC Trustee · MichelstadtN505WMAndrew Aircraft Sales LLC · Selmer, TNN505WTOlive Tyler A · Grass Valley, CAN505XCConnell Billie L II · Valdez, AKN505YRMarshall Douglas W · Blackfoot, IDN505ZRoddy Bonnie J · Holly Lake Ranch, TXN5060CEriksmoen Neal A · Fargo, ND
Back to AD 2007-04-19 R1