Skip to content

Registered aircraft · 58

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

N100GNFertitta Entertainment Holdings LLC · Houston, TXBuilt 2009 · S/N 6847 N10248Aeroxs Inc · Swainsboro, GABuilt 1977 · S/N 1502 N155JECjb Equipment Leasing LLC · Naples, FLBuilt 2003 · S/N 6633 N155RBAerospace Trust Management LLC Trustee · Wilmington, DES/N 6583 N155RDCastro Be LLC · Miami, FLBuilt 2000 · S/N 6580 N155TDAjd Aviation LLC · Dorado, PRS/N 6664 N155UMRegents Of The University Of Michigan · Ann Arbor, MIBuilt 2011 · S/N 6934 N156UMRegents Of The University Of Michigan · Ann Arbor, MIBuilt 2011 · S/N 6935 N157UMRegents Of The University Of Michigan · Ann Arbor, MIBuilt 2011 · S/N 6933 N225HHIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2015 · S/N 2961 N290TCBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 2905 N300EVAeroxs Inc · Swainsboro, GABuilt 1975 · S/N 1301 N332AValiair Limited Co Trustee · Casper, WYBuilt 2000 · S/N 2540 N332HCBank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 2319 N332NValiair Limited Company Trustee · Casper, WYBuilt 1994 · S/N 2408 N332RValiair Lc Trustee · Casper, WYBuilt 1991 · S/N 2347 N332XValiair Ltd Co Trustee · Casper, WYBuilt 1992 · S/N 2384 N339EVSouthern Utah University · Cedar City, UTBuilt 1974 · S/N 1285 N368EVValiair Limited Company Trustee · Casper, WYBuilt 1988 · S/N 2179 N406RGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1993 · S/N 2406 N44DSDs Air II LLC · Carrollton, VABuilt 2003 · S/N 6615 N506ACAir Center Helicopters Inc · Burleson, TXS/N 2707 N507ACAir Center Helicopters Inc · Burleson, TXS/N 2674 N509ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 2809 N510ACAir Center Helicopters Inc · Burleson, TXBuilt 2009 · S/N 2732 N511ACAir Center Helicopters Inc · Burleson, TXS/N 2681 N547HFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 2547 N551ACVertical Aviation No 1 LLC · Miami, FLBuilt 2012 · S/N 2842 N552ACVertical Aviation No 1 LLC · Miami, FLBuilt 2014 · S/N 2876 N553ACVertical Aviation No 1 LLC · Miami, FLBuilt 2014 · S/N 2913 N554ACVertical Aviation No 1 LLC · Miami, FLBuilt 2011 · S/N 2818 N557ACVertical Aviation No 1 LLC · Miami, FLBuilt 2014 · S/N 2900 N561ACAir Center Helicopters Inc · Burleson, TXBuilt 2012 · S/N 2821 N563ACAir Center Helicopters Inc · Burleson, TXBuilt 2012 · S/N 2825 N568ACVertical Aviation No 1 LLC · Miami, FLBuilt 2011 · S/N 2785 N569ACVertical Aviation No 1 LLC · Miami, FLBuilt 2011 · S/N 2790 N570ACVertical Aviation No 1 LLC · Miami, FLBuilt 2009 · S/N 2724 N572ACVertical Aviation No 1 LLC · Miami, FLBuilt 2009 · S/N 2728 N576ACVertical Aviation No 1 LLC · Miami, FLBuilt 2012 · S/N 2849 N5800ZPuerto Rico Electric Power Authority · San Juan, PRBuilt 1982 · S/N 2047 N582ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 2777 N590ACAir Center Helicopters Inc · Burleson, TXBuilt 2008 · S/N 2680 N591ACAir Center Helicopters Inc · Burleson, TXBuilt 2008 · S/N 2685 N594ACVertical Aviation No. 1 LLC · Miami, FLBuilt 2015 · S/N 2942 N597ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 2760 N605RAeroxs Inc · Swainsboro, GABuilt 1975 · S/N 1358 N6MVWing And Rotor Transportation Holdings LLC · Morristown, NJBuilt 2019 · S/N 7055 N725LLMilton S Hershey Medical Center · Hershey, PABuilt 2013 · S/N 6983 N758MMTrevor Corp DBA · Grayslake, ILS/N 6761 N759MMTrevor Corp DBA · Grayslake, ILBuilt 2007 · S/N 6777

Back to AD 2021-05-06