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.

N5658AEwartsville Flyers LLC · Pullman, WABuilt 1956 · S/N 28258 N5658REilers Scott D · Amissville, VABuilt 1965 · S/N 17253289 N5659AChaouki Rebecca · La Crosse, WIBuilt 1957 · S/N 28259 N5659TMorgan Peter Thomas · Bellingham, WABuilt 1964 · S/N 17251559 N565ADPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9991 N565CHTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2026 · S/N 172S13493 N565EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12877 N565NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10797 N565SPLlp Leasing Group LLC · Lewes, DEBuilt 2000 · S/N 172S8489 N5660RSpirit Hills Ranch LLC · Belgrade, MTBuilt 1965 · S/N 17253292 N5660TChoose You LLC · Twin Falls, IDS/N 17251560 N5661TSingletary Kenneth W · Newman Lake, WAS/N 17251561 N5662AMccafferty John · East Jordan, MIBuilt 1956 · S/N 28262 N5664ASale Reported · Spirit Lake, IDSale reportedBuilt 1956 · S/N 28264 N5665RLimmer Rita G · Redding, CABuilt 1965 · S/N 17253299 N5666ARonshausen Steven A · Circleville, OHBuilt 1956 · S/N 28266 N5666RSport Flying USA Inc · Ronkonkoma, NYBuilt 1965 · S/N 17253300 N5667KSmith John L · Renton, WABuilt 2001 · S/N 172S8991 N5667RBrazos River Aviation Group LLC · Mineral Wells, TXBuilt 1965 · S/N 17253302 N5668TShattuck Shaun R Jr · Coarsegold, CABuilt 1964 · S/N 17251568 N5669ABlanchette Charles · Payson, AZBuilt 1956 · S/N 28269 N5669RBeasley Marty J · Statesboro, GABuilt 1965 · S/N 17253304 N5669TClemmons Gavin T · Hopkins, MNBuilt 1964 · S/N 17251569 N566BGN566bg LLC · Leesburg, VABuilt 1979 · S/N 17272979 N566DDeland Aviation LLC · Deland, FLBuilt 2007 · S/N 172S10529 N566EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12878 N566NDCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10804 N566QButte Aviation Inc · Butte, MTBuilt 1979 · S/N 17273553 N566SPLlp Leasing Group LLC · Lewes, DEBuilt 2000 · S/N 172S8490 N5671AJarvis Peter S · Lebanon, CTBuilt 1956 · S/N 28271 N5674AStearns Edwin Ben Jr · Chandler, AZBuilt 1956 · S/N 28274 N5674RSpellman Mark · Novi, MIBuilt 1965 · S/N 17253312 N5674TPerma-Culture Inc · Dade City, FLBuilt 1964 · S/N 17251574 N5675AMarch David H Trustee · Lincoln, CABuilt 1956 · S/N 28275 N5675RN5675r Corp · Rochester, NYBuilt 1965 · S/N 17253313 N5675TPhillips Michael · Thompson Falls, MTBuilt 1964 · S/N 17251575 N5676ALakes Area Aviation LLC · Little Falls, MNBuilt 1956 · S/N 28276 N5678ABailey David D · Twentynine Palms, CABuilt 1956 · S/N 28278 N5679ALeblanc Kenneth E · Franklinton, LABuilt 1956 · S/N 28279 N5679RSandy River Flying Club · Wilton, MES/N 17253319 N5679TCataneda Jose · Yakima, WAFirst renewal noticeS/N 17251579 N567AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2014 · S/N 172S11418 N567DDAir America Flight Center LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9971 N567JWKingdom Power And Glory LLC · Colorado Springs, COBuilt 1999 · S/N 172S8187 N567NDMoore Aviation Inc · Beaver Falls, PABuilt 2008 · S/N 172S10805 N567SPAb Prop Plane II LLC · Metairie, LABuilt 2021 · S/N 172S12705 N5680AMoore John W · Salome, AZBuilt 1956 · S/N 28280 N5680RBraun Joshua H · Springfield, MOBuilt 1965 · S/N 17253320 N5681AKiesow Arthur W · Agua Dulce, CAS/N 28281 N5682ANewbury Arnold E · Phillips, WIBuilt 1956 · S/N 28282

Back to AD 90-06-03 R1