Skip to content

Registered aircraft · 20,687

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

N8088XSky 66 Aero LLC · Talala, OKBuilt 1961 · S/N 17248588 N80896Dsr-Cherokee 180 LLC · Dallas, TXBuilt 1976 · S/N 17266793 N8089ESkywarrior Flight Training Inc · Pensacola, FLBuilt 1978 · S/N 17272138 N808PEBarbers Point Flight School LLC · Kapolei, HIBuilt 2020 · S/N 172S12538 N808TPAvian Leasing LLC · Bremerton, WABuilt 1997 · S/N 17280141 N808UFMahoney Clinton D · Tecumseh, NEBuilt 1975 · S/N 17264869 N80906Red Door Aviation LLC · Dover, DEBuilt 1976 · S/N 17266796 N80912Bay Area Concrete LLC · Hayward, CABuilt 1976 · S/N 17266798 N80914Cp Aviation Inc · Santa Paula, CABuilt 1976 · S/N 17266799 N8091EChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172-75486 N8091LSzarek Carlee B · Los Osos, CABuilt 1967 · S/N 17256291 N80921Conerly Group LLC · Denham Springs, LABuilt 1976 · S/N 17266803 N80928Bellingham Aviation Services LLC · Bellingham, WABuilt 1976 · S/N 17266804 N8092BHering Robert A · Anchorage, AKBuilt 1957 · S/N 29892 N80931Augusta Aviation Inc · Augusta, GABuilt 1976 · S/N 17266806 N8093LNevins Mark B · Gresham, ORBuilt 1967 · S/N 17256293 N80941Holombo Ray J · Taylors, SCBuilt 1976 · S/N 17266810 N8094BRutherford County Air Rescue Squad · Rutherfordton, NCBuilt 1957 · S/N 29894 N8094XJenkins Matthew · Bend, ORS/N 17248594 N80952Registered aircraftBuilt 1976 · S/N 17266817 N80959Mets Flying Club Inc · Fairmount, INBuilt 1976 · S/N 17266819 N8095BYeagley Daun E III · Moraine, OHBuilt 1957 · S/N 29895 N8095XBall Christopher B · Homer, AKBuilt 1961 · S/N 17248595 N80961A S Air LLC · Lantana, FLBuilt 1976 · S/N 17266820 N80975N80975 LLC · Wilmington, DEBuilt 1976 · S/N 17266821 N8097LPeters Aero Plus LLC · Freeland, MIBuilt 1967 · S/N 17256297 N8097XKublank Nathan S · Sun Prairie, WIBuilt 1961 · S/N 17248597 N80982Reiselt Paul T F · Corinth, MSBuilt 1976 · S/N 17266825 N80985Mullins James C · Franklin, TNBuilt 1976 · S/N 17266826 N8098LJordan James R Trustee · Hermon, MEBuilt 1967 · S/N 17256298 N8098XRaphael Christopher M · Colorado Springs, COBuilt 1961 · S/N 17248598 N80991Flowers Robert Clyde III · Manchaca, TXBuilt 1976 · S/N 17266830 N80996Halley Dan R · Avery, TXBuilt 1976 · S/N 17266832 N8099BKlosterman Aviation LLC · Celina, OHBuilt 1957 · S/N 29899 N8099LMateaki Koreen · Anchorage, AKS/N 17256299 N809BTLouisville Aircraft Leasing LLC · Louisville, KYBuilt 1976 · S/N 17267437 N809STDiaz Natanael Luna · Toa Baja, PRS/N 17268873 N80BFAir Future Airways Corp · Miami, FLBuilt 2000 · S/N 172S8611 N80FPCarastro Enterprises LLC · Montgomery, ALBuilt 1978 · S/N 17271343 N80LULetourneau University · Longview, TXBuilt 2023 · S/N 172S12969 N8101LDickson Aaron M · Arkadelphia, ARS/N 17256301 N8101UWeirick Kelly M · Morganton, NCBuilt 1964 · S/N 17252001 N8101XBreuer Elizabeth · Horseshoe Bend, IDBuilt 1961 · S/N 17248601 N8103BJafar Farid G · Pine Bluff, ARBuilt 1957 · S/N 29903 N8103LSoaring Mrt LLC · Lake Charles, LABuilt 1967 · S/N 17256303 N8104BRomar Mark A · Massillon, OHBuilt 1957 · S/N 29904 N8104UMellen Dennis L · Peoria, ILBuilt 1964 · S/N 17252004 N8105LIowa Skyhawk LLC · Charles City, IAS/N 17256305 N8106XJones Wayne D · Huron, SDBuilt 1961 · S/N 17248606 N8107LConrad Adam C Jr · Duncansville, PABuilt 1967 · S/N 17256307

Back to AD 90-06-03 R1