Registered aircraft · 532

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.

N412BTPrestige Aviation LLC · Wixom, MIBuilt 2006 · S/N 550-1134 N413AGPljk LLC · Leechburg, PABuilt 1998 · S/N 560-5017 N416VGlacier Leasing LLC · Grand Rapids, MIBuilt 2000 · S/N 560-5109 N418KWNorthshore Air LLC · Mandeville, LABuilt 2001 · S/N 550-0959 N418RRBravo 18rr LLC · Wilmington, DEBuilt 2003 · S/N 550-1048 N41PRDk Air LLC · Scottsdale, AZBuilt 2003 · S/N 560-5325 N420DLPerfect Agreements Leasing Inc · Trabuco Canyon, CABuilt 2002 · S/N 560-5266 N421JBBravo 996 LLC · Boca Raton, FLBuilt 2001 · S/N 550-0996 N421LTSj Transportation Holdings LLC · San Angelo, TXBuilt 2004 · S/N 560-5370 N426CHCalhoun Transport LLC · Minneapolis, MNBuilt 2002 · S/N 560-5222 N430AMJems Air Inc · Glenwood, MDBuilt 2000 · S/N 560-0542 N432KSSsk Management 2 LLC · Bedford, OHBuilt 2001 · S/N 560-5169 N43NCCitation Encore LLC · Nashville, TNBuilt 2005 · S/N 560-0685 N444RFCascadian I LLC · Bellevue, WABuilt 2001 · S/N 560-0559 N447CCPace Aviation Corp · Chesapeake, VABuilt 2003 · S/N 560-5349 N452MMo Says LLC · Farmingdale, NYBuilt 2001 · S/N 560-5176 N461PSOmni Air LLC · Chesapeake, VABuilt 2000 · S/N 560-5059 N469MRBcrh LLC · Owasso, OKBuilt 2000 · S/N 560-5125 N469RSMdx Leasing LLC · Pompano Beach, FLBuilt 2000 · S/N 560-5082 N475CWTeam Aero LLC · Shawnee, KSBuilt 2000 · S/N 560-5080 N47HFCitation Msn 560-5153 LLC · Wilmington, DEBuilt 2003 · S/N 560-5347 N47NMMooch Aire LLC · Anchorage, AKBuilt 2005 · S/N 550-1112 N497PFBravo Air LLC · Sellersburg, INBuilt 2000 · S/N 550-0964 N499AVTeton Leasing LLC · Pocatello, IDBuilt 2005 · S/N 560-5602 N499EMPhysicians Air Transport LLC · Hot Springs, ARBuilt 1999 · S/N 550-0869 N4KSOa Air LLC · Lincoln, NEBuilt 1999 · S/N 560-5035 N4TLMorningstar Aviation II Inc · Wilmington, DEBuilt 2001 · S/N 560-0587 N500JDBeneficial Endeavors LLC · Wilmington, DEBuilt 2005 · S/N 560-5589 N500SXMerlin Aviation LLC · Indianapolis, INBuilt 1999 · S/N 560-5018 N500XLAbd Equipment LLC · Aledo, TXBuilt 2003 · S/N 560-5335 N501UPCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2002 · S/N 560-5252 N502BCOnarco2 LLC · Maurice, IABuilt 2000 · S/N 560-5098 N502EGX-Ray Lima Sierra LLC · Springfield, MOBuilt 2004 · S/N 560-5502 N502UPAlliance Aviation Group LLC · Wilmington, DEBuilt 2003 · S/N 560-5310 N502XLTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 560-6502 N503QFLmm Holding LLC · Cincinnati, OHBuilt 2001 · S/N 560-5205 N504SNSana Capital Holdings Delaware LLC · Dover, DES/N 560-5332 N504USunshine Airways Of N O LLC · New Orleans, LABuilt 2004 · S/N 560-0665 N507PDGr Aviation LLC · Saint Louis, MOBuilt 2002 · S/N 560-0596 N508UPCorporate Flight Management Incdba · Smyrna, TNBuilt 2005 · S/N 560-5546 N50CMWizard Aviation LLC · Redding, CABuilt 2004 · S/N 560-0661 N510CNC & N Aviation LLC · Coshocton, OHBuilt 2006 · S/N 550-1124 N510TKTk Constructors Inc · Muncie, INBuilt 2000 · S/N 560-5091 N512LLMcminn Law Firm Llp · Austin, TXBuilt 1999 · S/N 560-5023 N513VVInterstate Aviation LLC · Henderson, NVBuilt 2000 · S/N 560-5126 N51CAOklahoma Jet 560-5234 LLC · Ponca City, OKBuilt 2002 · S/N 560-5234 N51VTVirginia Tech Foundation Inc · Blacksburg, VABuilt 2000 · S/N 560-5072 N524DPDodson International Parts Inc · Rantoul, KSBuilt 2004 · S/N 560-5526 N524XAOn Three Angels Wings LLC · Melbourne, FLBuilt 2001 · S/N 550-0988 N528DXXitp LLC · Newark, DEBuilt 2000 · S/N 550-0906

Back to AD 2003-03-21