Skip to content

Registered aircraft · 20,683

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.

N55146Sky High Aviation LLC · Gonzales, LABuilt 1981 · S/N 17275119 N5514REaa Chapter 1606 Inc · Monticello, UTBuilt 1965 · S/N 17253089 N5515TCahill John Joseph Jr · Sebring, FLBuilt 1964 · S/N 17251415 N55160Davis Joseph S · Andalusia, ALBuilt 1981 · S/N 17275123 N55169Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17275126 N5516TBasley Reed M · Lanexa, VABuilt 1964 · S/N 17251416 N55179Rick Aviation Inc · Newport News, VABuilt 1981 · S/N 17275128 N5517RSk Transport LLC · Chicago, ILS/N 17253093 N55182Sofla Sky Solutions LLC · Deerfield Beach, FLS/N 17275129 N55187Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1981 · S/N 17275131 N5518GChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11391 N5518RWings N' Nuts · Bloomfield, NYS/N 17253094 N5518WChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11390 N55197Bartlett Aviation LLC · Louisville, KYBuilt 1981 · S/N 17275133 N5519JGoodwyn Thomas M · Las Vegas, NVBuilt 1980 · S/N 17273812 N5519THatcher John · Rathdrum, IDS/N 17251419 N551APCappe Investment Group LLC · Homestead, FLBuilt 1983 · S/N 17276056 N551ERSunrise Aviation Inc · Ormond Beach, FLBuilt 2007 · S/N 172S10548 N551ESNimno 551es LLC · Pompano Beach, FLBuilt 2005 · S/N 172S9902 N551NDCoast Flight Training And Management Inc · San Diego, CAFirst renewal noticeBuilt 2008 · S/N 172S10858 N551PGChavi LLC · Fredericksburg, TXBuilt 1978 · S/N 17271384 N55200Skyhawk Flyer LLC · Monticello, IABuilt 1981 · S/N 17275134 N5520DSwaeringen Eric · Snohomish, WABuilt 1979 · S/N 17272591 N5520NChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11400 N5520SChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11399 N5520TChayo Elinor · New York, NYBuilt 1964 · S/N 17251420 N5520UChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11398 N5520XUS Aviation Training Solutions Inc · Titusville, FLBuilt 2014 · S/N 172S11405 N55211Skylens LLC · Hammond, LABuilt 1981 · S/N 17275135 N55218Christiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11424 N5521QEckmann Sheri L · Santa Barbara, CABuilt 2014 · S/N 172S11422 N5521RRpm Commander Holdings Inc · Deerfield Beach, FLS/N 17253098 N5521SChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11421 N5522A5522a LLC · Bethany, OKBuilt 2014 · S/N 172S11423 N5522SAmeriflyers Of Texas Inc · Addison, TXBuilt 2014 · S/N 172S11430 N5522XChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11429 N55231Golf November Aero LLC · Sunnyvale, CABuilt 2014 · S/N 172S11414 N55234Alien Invaders LLC · Medina, WABuilt 2014 · S/N 172S11415 N55236Bobnal LLC · Conway, SCBuilt 1981 · S/N 17275139 N5523QDolphin Leasing LLC · Daytona Beach, FLBuilt 2014 · S/N 172S11412 N5523RPlett John · Anaconda, MTBuilt 1979 · S/N 172RG0069 N5523VDolphin Leasing LLC · Daytona Beach, FLBuilt 2014 · S/N 172S11413 N55242Hills Holding · Newark, DEBuilt 1981 · S/N 17275142 N55246Kadena Aero Club · Apo, APBuilt 1981 · S/N 17275143 N55250Colorado Aircraft Corp · Watkins, COBuilt 1981 · S/N 17275144 N55256Notam Aviation LLC · Portage Des Sioux, MOBuilt 1981 · S/N 17275146 N5525TDavis Ronnie L · Okmulgee, OKBuilt 1964 · S/N 17251425 N55264Ace Aircraft Leasing Inc · Nazareth, PABuilt 1981 · S/N 17275147 N5526JBravo Leasing LLC · Daytona Beach, FLBuilt 2014 · S/N 172S11484 N5526RQualitair LLC Trustee · MichelstadtS/N 172RG0070

Back to AD 90-06-03 R1