Skip to content

Registered aircraft · 5,443

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

N4140WBird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843228 N4141UMoss James L · Lansing, IABuilt 1998 · S/N 2843125 N4142QWisconsin Aviation Four Lakes Inc · Madison, WIBuilt 1999 · S/N 2843207 N4143ASkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843217 N4143USwerczek Gerald Edward Jr · Tallahassee, FLBuilt 1999 · S/N 2843308 N4144KBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843145 N4144PChandler Air Service Inc · Chandler, AZBuilt 1998 · S/N 2843121 N4144XSkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843267 N4145AUniverstiy Of Illinois · Savoy, ILBuilt 1998 · S/N 2843150 N4145GUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843151 N4145XUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843152 N4146DBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843153 N4146RUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843160 N4146TUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843168 N4147GStinson Aaron M · Anchorage, AKFirst renewal noticeBuilt 2000 · S/N 28-43364 N4147KUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843169 N4147TChandler Air Service Inc · Chandler, AZBuilt 1999 · S/N 2843272 N41487Skywest Leasing Inc · St George, UTBuilt 1998 · S/N 2843179 N4148DSkywest Leasing Inc · St George, UTBuilt 1998 · S/N 2843170 N4148VUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843178 N4149ABoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843189 N4149CBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843190 N4149GBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843191 N4149TCrosswinds Flying Club Inc · Bloomington, ILBuilt 1998 · S/N 2843192 N414VTSnellmeyer Aviation LLC · Murrieta, CABuilt 1977 · S/N 28R-7737104 N414WMChristiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 2844110 N4155GBaker Aviation LLC · Fort Worth, TXBuilt 1989 · S/N 2837017 N41598Fox Flying Club Inc · Wheaton, ILBuilt 1999 · S/N 2843290 N415CAFly For Fun Aircraft LLC · Baltimore, MDS/N 2843215 N415GKCentral Clinton County Flying Club Inc · Jersey Shore, PABuilt 1982 · S/N 28-8290151 N415KMTmjb Holdings LLC · Chandler, AZS/N 28-8390081 N415MSNextgen Flight Academy Inc · Riverside, CABuilt 1978 · S/N 28-7816430 N415PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843448 N415SGriffing Flying Service Inc · Port Clinton, OHBuilt 1978 · S/N 28-7990041 N4160FYatin Servet · Weston, MABuilt 2000 · S/N 2844028 N4161PRegistered aircraftBuilt 1999 · S/N 2843309 N4161ZAri Ben Aviator Inc · Fort Pierce, FLBuilt 1998 · S/N 2843129 N4163WRedlands Flying Club · Redlands, CABuilt 1998 · S/N 2843127 N41641Gunderson Roger · Fort Collins, COBuilt 1999 · S/N 2843276 N4164YBoard Of Trustees · Savoy, ILBuilt 2000 · S/N 2843317 N4165EJauer Brant A · Saukville, WIBuilt 1999 · S/N 2843291 N4165UInter American University Of Puerto Rico · Bayamon, PRBuilt 1998 · S/N 2843200 N4166FStalworth Leasing Inc · Burr Ridge, ILBuilt 1999 · S/N 2843263 N4166HBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843119 N4167KSkywest Leasing Inc · St George, UTBuilt 2000 · S/N 2843342 N4167LPlane Nonsense Inc · Middletown, DEBuilt 2000 · S/N 2843318 N416CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881121 N416PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843438 N4170LOsborn Allan R Trustee · Springfield, VABuilt 2000 · S/N 28-43387 N4170TVwfusco Aircraft Management LLC · Stratford, CTBuilt 2000 · S/N 2843390

Back to AD 2016-07-21