Registered aircraft · 523

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

N18TMAerownership North American Services Inc Trustee · Wilmington, DEBuilt 2001 · S/N 9090 N18WZEwz Aviation Inc · Santa Monica, CABuilt 2009 · S/N 9338 N190JAJacob Wing LLC · New York, NYBuilt 2008 · S/N 9274 N1955QGmdair Corp · New York, NYBuilt 2014 · S/N 9645 N1989Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 9039 N1ARAl Rushaid Aviation Ltd · Jacksonville, FLBuilt 2000 · S/N 9061 N1CFNorthern Holdings LLC · Queensbury, NYBuilt 2012 · S/N 9519 N1FEFederal Express Leasing Corp · Memphis, TNBuilt 2017 · S/N 9815 N1WWAmbleur II LLC · Palm Beach Gardens, FLBuilt 2017 · S/N 9808 N203BHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 60184 N205ELInvemed Securities Inc · New York, NYBuilt 2006 · S/N 9201 N20HQP2 Aviation Management LLC · Memphis, TNS/N 9272 N20RGBsr Aviation LLC · Crestwood, KYBuilt 2006 · S/N 9190 N20SQFlying Plane LLC · Purchase, NYBuilt 2012 · S/N 9491 N2100LLasai Aviation II LLC · Manassas, VABuilt 2023 · S/N 60100 N211PBJoust Capital III LLC · Dulles, VABuilt 2023 · S/N 60101 N2121JSbij LLC · Wilmington, DEBuilt 2015 · S/N 9685 N212APOneida II LLC · Wilmington, DEBuilt 2000 · S/N 9063 N212LFLeflight Supreme LLC · Wilmington, DEBuilt 2020 · S/N 60038 N212NYFlyjk LLC · New York, NYBuilt 2025 · S/N 60189 N214MDHdb Aviation LLC · Farmers Branch, TXBuilt 2004 · S/N 9152 N215TMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 9719 N218ALCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 9260 N218JJRegistered aircraftBuilt 2010 · S/N 9403 N219BYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 9775 N219GXCmc 9256 LLC · Lewes, DEBuilt 2007 · S/N 9256 N220FBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 9011 N225BKCxair Holdings Inc · Stuart, FLBuilt 2018 · S/N 9876 N226RRegistered aircraftAssigned (import), pending cancellationS/N 60226 N226SJSsc Asset Co II LLC · Irvine, CABuilt 2001 · S/N 9095 N228SKSkechers U S A Inc · Manhattan Beach, CABuilt 2014 · S/N 9643 N228SSSws Venture Capital Services LLC · Los Angeles, CABuilt 2003 · S/N 9124 N2313ARegistered aircraftBuilt 2019 · S/N 9858 N2320Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 60008 N232HFHf Jet LLC · Beverly Hills, CABuilt 2013 · S/N 9572 N23UCBay Equipment LLC · Miami, FLBuilt 2000 · S/N 9064 N240WLCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 9696 N241EABozeman Direct LLC · Summit, NJBuilt 2011 · S/N 9465 N244BDBombardier Aerospace Corp · Dallas, TXS/N 60244 N247WEWwe Jet Services Inc · Stamford, CTBuilt 2007 · S/N 9245 N263JMValhalla Aviation LLC · Coral Gables, FLBuilt 2023 · S/N 60112 N265HTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 9197 N2707Corporate Lift LLC · Farmington Hills, MIBuilt 2012 · S/N 9489 N271GLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 9134 N291SRL3harris Technologies Inc · Greenville, TXBuilt 2023 · S/N 60107 N293JGEscalante By Grace LLC · Fort Worth, TXBuilt 2008 · S/N 9293 N2ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 9455 N2FEFederal Express Leasing Corp · Memphis, TNBuilt 2018 · S/N 9818 N2JWJw Air LLC · Houston, TXBuilt 2011 · S/N 9461 N2MGCherokee Aviation LLC · Roseburg, ORBuilt 2014 · S/N 9603

Back to AD 2020-03-21