AD 90-02-13
Registered aircraft · 3,863
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:90-02-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-02-13')
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:90-02-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-02-13') 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.
N3068LMirage Air Ltd · Wilmington, DENon-citizen corporation, flight hours not reportedN3069DSmith Gregory E · White Lake, MIN306PMBc 414 LLC · Vineyard Haven, MAN306TBApex Aviation Holding LLC · Kalispell, MTN3070LClark Kenneth N · Tempe, AZN3071LRegistered aircraftN3073LSheakley John W DBA · Meadville, PAN3075LAlvis Michael E · Parkton, NCN3079LTff Inc · Parma, MIN307FMNorris Aviation LLC · Mansfield, TXN3083LPrice Randy L · Pahrump, NVN3088LRice James M · Austin, TXN3091DBella Farms Inc · Hayes Center, NEN3091LAbbasi Babak · Murrieta, CAN3094DAberdeen Pilots LLC · Boerne, TXN3095DIrvine William G · Rosamond, CAN30DTShelton Sharon Shay · Abilene, TXN30EEEnterprises Aviation Inc · Piedmont, SDN30FBBmg Aviation Leasing LLC · Bloomington, INN30HBN30hb LLC · North Miami, FLN30HCKinetic Concepts LLC · Pensacola, FLN30LPDialysis Clinic Inc · Nashville, TNN30LTJuans Adios LLC · Newark, DEN30PTGas Aviation LLC · Decatur, TNN30RWSaltzy Seas LLC · Loxahatchee, FLN30SSN30ss LLC · Dover, DEN30TAero Quest LLC · Olive Branch, MSN3101TMission Air LLC · Charlotte, NCN310ACJulie Dorst LLC · Kalispell, MTN310AFSelwa Michael A · Oconomowoc, WIN310AHGraydon Bilal R · Melbourne, FLN310AJPj Aviation Holding LLC Trustee · Eden Prairie, MNN310ARHales Gutter Guys LLC · Cottonwood, AZN310ATBelknap Scott M · Temecula, CAN310AWBetty Eric · Old Hickory, TNN310BBF & F Aviation LLC · Memphis, TNN310BDSale Reported · Fort Wayne, INSale reportedN310BGFlairships LLC · Durham, NCN310BJJ A Flight Services LLC · Sugar Grove, ILN310BMTeam 67 LLC · Mount Pleasant, IAN310BSKwe Inc · Melbourne Beach, FLN310BVExec Air Inc Of Naples · Naples, FLN310CBN310cb LLC · Buford, GAN310CCLance Johnson Ministries Inc · Calhoun, GAN310CFSouthern Illinois University DBA · Murphysboro, ILN310CGHoffert Stephen · Alexander, NCN310CJCj Marketing Inc · Saint John, INN310CKSt Charles Flying Service Inc · Portage Des Sioux, MON310CLSinclair Bradley W · Melbourne, FLN310CMAir Positive LLC · Selbyville, DE
Back to AD 90-02-13