Registered aircraft · 353

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:2013-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:2013-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:2013-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:2013-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:2013-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:2013-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.

N50BReina Capital II LLC · Miami, FLBuilt 2011 · S/N 22234 N50RPPenske Corp · New Castle, DEBuilt 2000 · S/N 56008 N512WFMetro Aviation Inc · Shreveport, LABuilt 2010 · S/N 0946 N517QAAltus Aviation Management · Las Vegas, NVBuilt 2018 · S/N 22708 N523MTMed-Trans Corp · Denton, TXBuilt 2009 · S/N 0821 N524MTMed-Trans Corporation · Denton, TXBuilt 2012 · S/N 1039 N524WFCarolinas Healthcare System DBA · Charlotte, NCBuilt 2009 · S/N 0830 N527BFAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0697 N530KSBristow LLC · Lake Charles, LABuilt 2006 · S/N 11694 N531HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2016 · S/N 22366 N531LNAir Methods LLC · Greenwood Village, COFirst renewal noticeBuilt 2006 · S/N 0474 N533LCAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0555 N535DETentacle Corp · Walnut Creek, CABuilt 2013 · S/N 1100 N535LLMercy Hospital Springfield · Springfield, MOBuilt 2009 · S/N 0817 N535LNAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0365 N551HUAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0490 N555YEReach Air Medical Services LLC · Santa Rosa, CABuilt 2007 · S/N 0561 N556MTMed Trans Corp · Denton, TXBuilt 2017 · S/N 1253 N558MTMed-Trans Corporation · Denton, TXBuilt 2012 · S/N 1073 N567HBCj Leasing LLC Trustee · Lakeland, FLBuilt 2010 · S/N 11780 N577MTMed-Trans Corporation · Denton, TXBuilt 2017 · S/N 1249 N57HRSeminole Tribe Of Florida DBA · Davie, FLBuilt 2013 · S/N 22317 N586AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0709 N586WHMetro Aviation Inc · Shreveport, LABuilt 2013 · S/N 1096 N595JGJoe Gibbs Racing LLC · Huntersville, NCBuilt 2001 · S/N 56026 N599MSAir Med Services LLC · Lafayette, LAS/N 0684 N59PDiesel Acquisitions LLC · Milpitas, CABuilt 2007 · S/N 22036 N59ZXAs 355 LLC · Gay, GABuilt 2006 · S/N 11683 N601MTMed-Trans Corp · Denton, TXBuilt 2012 · S/N 1040 N602MTMed-Trans Corp · Denton, TXBuilt 2012 · S/N 1063 N608WGsh Crows Nest LLC · Boston, MABuilt 2007 · S/N 0575 N611NBCisco Aero LLC · Cisco, TXBuilt 2012 · S/N 57072 N613HAHa 109e LLC · Flushing, NYBuilt 2006 · S/N 11674 N615BDDeckoff Stephen H · St Thomas, VIBuilt 2015 · S/N 1193 N615LFAir Methods LLC · Greenwood Village, COFirst renewal noticeBuilt 2004 · S/N 0362 N618HRBoardwalk Air I LLC · Atlantic City, NJBuilt 2020 · S/N 22419 N621SCSouth Bay Helicopter Service Inc · Hayward, CAS/N 22078 N631HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2016 · S/N 22349 N635DHMetro Aviation Inc · Shreveport, LABuilt 2005 · S/N 0414 N641ECMetro Aviation Inc · Shreveport, LABuilt 2008 · S/N 0641 N655DVMed-Trans Corp · Denton, TXBuilt 2012 · S/N 1057 N655JTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 1054 N65CJBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 11051 N665MTMed-Trans Corp · Denton, TXBuilt 2006 · S/N 0466 N68NMNorth Memorial Healthcare · Brooklyn Center, MNBuilt 2008 · S/N 22076 N69KGBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2006 · S/N 22021 N6JEEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 11095 N6VZLeonardo Helicopters US Corp · Philadelphia, PABuilt 2000 · S/N 11099 N706WPCity Of Los Angeles Department Of Water & Power · Van Nuys, CABuilt 2023 · S/N 57488 N714GEPolar Star Corp · Kalispell, MTBuilt 1966 · S/N 0060

Back to AD 2013-03-21