Skip to content

Registered aircraft · 534

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

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:2003-03-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-03-21') ORDER BY n_number

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:2003-03-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-03-21')
  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:2003-03-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-03-21')
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.

N560LALee Aerospace Inc · Wichita, KSBuilt 2003 · S/N 560-5334 N560LFCamelot Express LLC · Roswell, GABuilt 2004 · S/N 560-0662 N560LLBar Wr Air Services LLC · Dallas, TXBuilt 2000 · S/N 560-5104 N560LTLife Time Inc · Chanhassen, MNBuilt 2000 · S/N 560-0541 N560MCJem Air Holdings LLC · Raleigh, NCBuilt 2001 · S/N 560-5157 N560MLMld Leasing LLC · Warsaw, INBuilt 1999 · S/N 560-5027 N560MRCitation Associates Inc · New Castle, DEBuilt 2002 · S/N 560-0594 N560PDAcs Air Investors LLC · Wilmington, DEBuilt 2003 · S/N 560-5311 N560PPEncore Aviation Holdings LLC · Jacksonville, FLBuilt 2005 · S/N 560-0687 N560RMKa LLC · New Paris, INBuilt 2004 · S/N 560-0658 N560RNWrn Air LLC · Wilmington, DEBuilt 2001 · S/N 560-5212 N560SAGolden Air Inc · Dover, DEBuilt 2004 · S/N 560-0660 N560SGN560sg Leasing LLC · Wichita, KSBuilt 2002 · S/N 560-5308 N560TPPollard Aircraft Sales Inc · Fort Worth, TXBuilt 2001 · S/N 560-5217 N560TVVerdoorn Daryl R Trustee · Saint Paul, MNBuilt 2005 · S/N 560-5545 N560TWT W Lewis-Aviation LLC · Scottsdale, AZBuilt 2005 · S/N 560-5585 N560VFVictor Foxtrot LLC · Scott City, KSBuilt 2000 · S/N 560-5135 N560VSHillabrand Heir LLC · Greenville, SCBuilt 2000 · S/N 560-5066 N560WDAbbott Air Inc · Hydro, OKBuilt 2003 · S/N 560-0643 N560WG560wg LLC · Dover, DEBuilt 1999 · S/N 560-5028 N560WLTres Amigos Aviation LLC · Dover, DEBuilt 1998 · S/N 560-5012 N560XETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 560-5103 N560ZFN560lj LLC · San Jose, CABuilt 2004 · S/N 560-5525 N561BERegistered aircraftBuilt 2026 · S/N 560-6511 N561FPZulu Romeo LLC · Ontario, ORBuilt 2001 · S/N 560-0561 N561JLFalcon Aviation Ltd Co · San Diego, CABuilt 2004 · S/N 560-5361 N562DDZoe Aviation Inc · Euless, TXBuilt 2000 · S/N 560-5108 N562HCH2c Air LLC · Cincinnati, OHBuilt 2003 · S/N 560-5350 N562JLMonreve LLC · Jacksonville, FLBuilt 2002 · S/N 560-5248 N562LDCasey Co · Long Beach, CABuilt 2004 · S/N 560-5532 N562TSJ-Six Enterprises LLC-J-Six Aviation Holdings Seri · Seneca, KSBuilt 2001 · S/N 560-5178 N563CSTulsa Xls LLC · Tulsa, OKBuilt 2005 · S/N 560-5563 N563MMenard Inc · Eau Claire, WIBuilt 2001 · S/N 560-0550 N564MMenard Inc · Eau Claire, WIBuilt 2001 · S/N 560-0569 N564TATeam Aero LLC · Shawnee, KSS/N 560-5249 N564WS4way Split LLC · Bay Minette, ALBuilt 1998 · S/N 560-5014 N566FMidwest Ethanol Transport LLC · Granite Falls, MNBuilt 2005 · S/N 560-5606 N567MCN63xp LLC · Brea, CABuilt 2003 · S/N 5605357 N568TXSpray Brothers Aviation LLC · Great Bend, KSBuilt 2001 · S/N 560-0558 N569MKKam Air LLC · High Point, NCBuilt 1998 · S/N 560-5006 N56FSSunny Skies Kc LLC · Leawood, KSBuilt 2002 · S/N 560-0600 N56KGBlue Yonder LLC · Portland, ORBuilt 2001 · S/N 560-0563 N56WZAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 560-5156 N571BCInternational Bank Of Commerce · Oklahoma City, OKBuilt 1999 · S/N 560-5013 N577PSPad One Holdings LLC · Wilmington, DEBuilt 2005 · S/N 560-5581 N579MJet Air Inc · Galesburg, ILBuilt 2006 · S/N 550-1133 N579MHJ1ap LLC · Naples, FLBuilt 2000 · S/N 560-5071 N582MPPaladin Adventures LLC · Westlake, TXBuilt 2026 · S/N 560-6517 N583TL518mv Air LLC · Modesto, CABuilt 2001 · S/N 560-0583 N586DZZeeco Inc · Broken Arrow, OKBuilt 2005 · S/N 560-5592

Back to AD 2003-03-21