AD 2015-20-13
Registered aircraft · 5,444
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:2015-20-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:2015-20-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:2015-20-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:2015-20-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.
N241JAHot Wings Aviation LLC · Indianapolis, INN241NDSkyborne Airline Academy Inc · Vero Beach, FLN241ZAlpha Tango Aircraft LLC · Wilmington, DEN2421WJohnston John · Sheboygan, WIN2425MTap Solutions Inc · San Diego, CAN2427M18 Rwy LLC · Falmouth, MEN2427UGalante Anthony R · Saint Clair, MIN2429TKlassen William Peter · Davis, CAN242AAFf22 LLC · Scottsdale, AZN242NDHaye Patrick W · Minot, NDN242NPBa Flight Experience LLC · Margate, FLN2433MHarkey Aviation LLC · Sherrills Ford, NCN2434MSky'S The Limit Flying Club Inc · Findlay, OHN2435MBrolan Aviation LLC · Kansas City, MON2436MVenture Aviation Inc · Arlington, MAN2436YAlpha Flight Academy · Concord, CANon-citizen corporation, flight hours not reportedN243AAFf22 LLC · Scottsdale, AZN243DWSijtsma Wouter · Ladson, SCN243GArcher Aero LLC · Wilmington, DEN243JAYale Companies LLC DBA · Indianapolis, INN243MGGeorgia Aviation Authority · Eastman, GAN244AAFf22 LLC · Scottsdale, AZN244JALee A Archer Jr Red Tail Youth Flying Program Inc · New Windsor, NYN244MGGeorgia Aviation Authority · Eastman, GAN244NDPlane Nonsense Inc · Middletown, DEN2450UDouble D Flyboys LLC · Taylorsville, UTN2458QM&M Aviation LLC · South Windsor, CTN245AAFf22 LLC · Scottsdale, AZN245CACoast Flight Training And Management Inc · San Diego, CAN245DWJr Aircraft LLC · Dayton, OHN245TCTexas State Technical College · Waco, TXN245TPStrable Sam · Cecil, OHN2460QHamilton Aviation Group LLC · Lula, GAN2460UAccelerated Aviation Instruction LLC · Owatonna, MNN2461QJessi Air Ltd · West Salem, OHN2464QWilson Jeff · White Bluff, TNN246CBCalifornia Baptist University · Riverside, CAN246NDGlobal Aviation Corp · Farmingdale, NYN2471USchroeder Nyla R · Minneapolis, MNN2473WCahill Chad · Edmond, OKN2473YFunderburg Erskine R · Pell City, ALN2476MPremier Flight Center LLC · Hartford, CTN2477SAverett University · Danville, VAN2478VKozura Ronald J · Pine Grove, PAN247MGGeorgia Aviation Authority · Eastman, GAN2480VLyons Emily A · Homewood, ALN2485XLostetter Evan · Bakersfield, CAN2488MMeads Rodney L · Camden, NCN2488PPs Engineering Inc · Lenoir City, TNN248CBCalifornia Baptist University · Riverside, CA
Back to AD 2015-20-13