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.

N92704Gull Wing Flight LLC · Pt Pleas Bch, NJBuilt 1973 · S/N 17261605 N92720Registration Pending · Champaign, ILRegistration pendingS/N 17261608 N92722Bryant David A · Walhalla, SCBuilt 1973 · S/N 17261609 N9272HBlackbird 71 LLC · Rockford, ILBuilt 1975 · S/N 17266060 N92747Wiles Donald · Shrewsbury, MABuilt 1973 · S/N 17261613 N9274HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266062 N92753Mccollum J R · Mount Pleasant, TXBuilt 1973 · S/N 17261614 N92777Macatawa Flyers Inc · Allegan, MIBuilt 1973 · S/N 17261616 N9277HChorman Spraying LLC · Milton, DEBuilt 1975 · S/N 17266065 N92789N5746u LLC · Dover, DES/N 17261619 N927AZN927az LLC · Miami, FLBuilt 2002 · S/N 172S9090 N927CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8915 N927GHB R S Leasing Inc · Wilmington, DEBuilt 2005 · S/N 172S10024 N927GPChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12409 N927TCWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264152 N927TSM & G Aircraft Management LLC · Aurora, ORBuilt 2023 · S/N 172S13067 N9280MRiley Dean A · Friday Harbor, WABuilt 1972 · S/N 17260490 N9280TChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12413 N92810Dilse Brian R · Grand Forks, NDBuilt 1973 · S/N 17261626 N92817Millner James W Sr · Soldotna, AKBuilt 1973 · S/N 17261628 N9281ABuiqui Aerospace Corp · Kissimmee, FLBuilt 2022 · S/N 172S12787 N92837Staszak Sandra · Martinsville, ILBuilt 1973 · S/N 17261631 N9283AFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12788 N9283CFoerschler Dale · North Aurora, ILBuilt 1980 · S/N 17273783 N92845Hainet Aero LLC · Wilmington, DEBuilt 1973 · S/N 17261633 N92855Falcon Flying Club · Mesa, AZBuilt 1973 · S/N 17261634 N9285HOrion Aviation Aircraft LLC · Carlsbad, CABuilt 1975 · S/N 17266068 N92873Sonday Terrance P · Spring, TXBuilt 1973 · S/N 17261636 N92878Jackson Richard L · Indianapolis, INBuilt 1973 · S/N 17261638 N9287MRkm Leasing LLC · Greenwich, CTBuilt 2011 · S/N 172S11112 N92886Lewis John E · Clayton, NJBuilt 1973 · S/N 17261640 N92888Knudsen Wayne D · Dakota City, NEBuilt 1973 · S/N 17261641 N92889Miller Andy · Marana, AZBuilt 1973 · S/N 17261642 N92894Smith Rex H · Fort Bragg, CABuilt 1973 · S/N 17261644 N928FGMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10371 N928HPeterson Michael A · White Salmon, WABuilt 1964 · S/N 17251734 N928LPMontana Freedom Riders LLC · Corvallis, MTBuilt 2001 · S/N 172S8928 N928MAAnson Air LLC · Sugar Land, TXFirst renewal noticeBuilt 1999 · S/N 17280785 N928ZAFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12786 N92908C-140 Company LLC · Pensacola, FLBuilt 1973 · S/N 17261647 N9291HDawson William F Jr · Port Hueneme, CABuilt 1975 · S/N 17266071 N9292HBlackhawk Flying Club Inc · Rockford, ILBuilt 1975 · S/N 17266072 N92934Service Oriented Aviation Readiness (Soar) · Bolivar, MOBuilt 1973 · S/N 17261650 N92945Fla Inc · Wilmington, DEBuilt 1973 · S/N 17261655 N9295HMiami Seaplane Tours Inc · Miami, FLBuilt 1975 · S/N 17266075 N9296HSmith Richard A · Burnsville, MNBuilt 1975 · S/N 17266076 N92970Elizabeth City State University · Elizabeth City, NCBuilt 2011 · S/N 172S11124 N929BMSuntops Aircraft Holding LLC · Lakeland, FLBuilt 1975 · S/N 17265826 N929LSFlying Tigers Flight School Ltd · Houston, TXBuilt 1972 · S/N 17260660 N92CCCanadian Co Sheriffs Office · El Reno, OKBuilt 1965 · S/N 17253144

Back to AD 90-06-03 R1