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.

N385RTIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2018 · S/N 22385 N388PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 0701 N389PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 0710 N390PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 0733 N391PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 0748 N399BTBell Textron Inc · Fort Worth, TXS/N 57013 N39RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2009 · S/N 0850 N405EHMed-Trans Corp · Denton, TXBuilt 2008 · S/N 0739 N406EHMed-Trans Corp · Denton, TXBuilt 2008 · S/N 0726 N408RMValiair Lc Trustee · Casper, WYBuilt 2024 · S/N 2252 N426PJHelibro LLC · Red Bluff, CABuilt 2011 · S/N 57057 N427BWInland Empire Air LLC · Fontana, CAS/N 56081 N427JJCheca LLC · Jackson, WYBuilt 2003 · S/N 56039 N427PGFw Equipment Leasing LLC · Batesville, ARBuilt 2000 · S/N 56019 N427TPSky West Aviation Inc Trustee · Albuquerque, NMS/N 56015 N427UVVase Corp III · Wilmington, DEBuilt 2009 · S/N 56077 N429CHVentus Mf LLC · Boise, IDBuilt 2010 · S/N 57014 N429HCDelta Jet Ltd · Glastonbury, CTBuilt 2010 · S/N 57019 N429NABell Textron Inc · Fort Worth, TXBuilt 2010 · S/N 57009 N429SLVentus Mf LLC · Boise, IDBuilt 2010 · S/N 57007 N429TVTennessee Valley Authority · Muscle Shoals, ALBuilt 2020 · S/N 57395 N429TXTextron Inc · Warwick, RIS/N 57018 N429VGSafety Logistics LLC · West Palm Beach, FLS/N 57025 N429WMBell Textron Inc · Fort Worth, TXBuilt 2011 · S/N 57056 N42FPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 56053 N42NMNorth Memorial Health Care · Brooklyn Center, MNBuilt 2006 · S/N 22012 N430TMBristow LLC · Lake Charles, LABuilt 2006 · S/N 0457 N431HCUS Bank Na · Marshall, MNBuilt 2019 · S/N 22404 N433AKHelinet Aviation Services LLC · Van Nuys, CABuilt 2011 · S/N 11797 N433CMCarolinas Healthcare System DBA · Charlotte, NCBuilt 2009 · S/N 0755 N435AKHelinet Aviation Services LLC · Van Nuys, CABuilt 2009 · S/N 11762 N435DHMary Hitchock Memorial Hospital · Lebanon, NHBuilt 2016 · S/N 1233 N435LLMercy Hospital Springfield · Springfield, MOBuilt 2008 · S/N 0758 N436CMCarolinas Healthcare System DBA · Charlotte, NCBuilt 2009 · S/N 0800 N437MLRoyalton Development Corp · Remsenburg, NYBuilt 2011 · S/N 56084 N438ASWest States Leasing Inc · Medford, ORBuilt 2010 · S/N 57021 N444YEReach Air Medical Services LLC · Santa Rosa, CABuilt 2007 · S/N 0599 N449CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 22066 N450MTMed-Trans Corp · Denton, TXBuilt 2010 · S/N 0950 N452MTMed-Trans Corp · Denton, TXBuilt 2011 · S/N 0974 N456MTMed-Trans Corp · Denton, TXBuilt 2009 · S/N 0854 N459MTMed-Trans Corp · Denton, TXBuilt 2010 · S/N 0928 N45BZLogistics Business Services LLC · Cheshire, CTBuilt 2012 · S/N 22284 N45SHSunflower Aviation LLC · Greenleaf, KSBuilt 2007 · S/N 22046 N461MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 1008 N48SHIndiana Helicopters LLC · Fort Wayne, INBuilt 2010 · S/N 22214 N492AEAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0278 N493NCWest States Leasing Inc · Medford, ORBuilt 2010 · S/N 57015 N508CFAerotrust Services Corp Trustee · Wilmington, DEBuilt 2001 · S/N 11103 N508TJMercy Flight Inc · Buffalo, NYBuilt 2017 · S/N 57333

Back to AD 2013-03-21