Skip to content

Registered aircraft · 81,720

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

N207ENWhitman Bruce R · Lowell, MIBuilt 2012 · S/N 06 N207ERIndiana Helicopters LLC · Fort Wayne, INBuilt 2017 · S/N 1207 N207ESPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020254 N207GAGreer Robert H · Hudson, NHBuilt 1992 · S/N 3207 N207HPCampbell James W · Geneva, ALBuilt 1982 · S/N 17275543 N207JJN207jj LLC · Mesa, AZBuilt 2020 · S/N 1183-2020 N207JTTozer John E · Orono, MEBuilt 1979 · S/N 6006317961200 N207JVSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 0121 N207LSNightbreak Aviation LLC · Houston, TXBuilt 1968 · S/N 680072 N207LTFreitag William W Jr · Lakeway, TXBuilt 2011 · S/N 91680 N207MZLeitch Keith L · Merlin, ORBuilt 2008 · S/N 82461 N207PBBernstein Petra M · Salisbury, MDBuilt 2006 · S/N 18281771 N207PDFirefly Leasing Inc · South Carver, MABuilt 2003 · S/N 1330 N207PKDufault Daniel R · Lincolnville, MEBuilt 2019 · S/N 3320 N207RCSawka Craig · Palm City, FLBuilt 2021 · S/N 70533 N207RDSpry Brent A · Madison, INBuilt 1977 · S/N AA5A0449 N207SADyer LLC · Dyer, TNBuilt 1998 · S/N 18280140 N207SFTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13485 N207TJBoos Timothy J · Fort Atkinson, WIBuilt 2007 · S/N 71909 N207VRB&C Properties LLC · Bristol, WIS/N 32-58 N20804Ceddia Stephen J · Framingham, MABuilt 1974 · S/N 17263841 N20807Dyess William C · Franklin, TNFirst renewal noticeBuilt 2005 · S/N 25772 N2080EBean James P · Tulsa, OKBuilt 1978 · S/N 17271147 N2080VMcguire Rental Properties LLC · Prescott, ARBuilt 1979 · S/N 28-7916322 N20811Rtd Aviation LLC · Hillsborough, NJBuilt 1974 · S/N 17263843 N20818N20818 LLC · Wilmington, DES/N 172S12579 N2081CTrident Aircraft Inc · Easton, MDBuilt 1978 · S/N 28-7916128 N2081SPlane Nonsense Inc · Middletown, DEBuilt 2005 · S/N 172S10023 N2081TBaker Holdings LLC · Bedford, PAS/N 28R-7135025 N20821Danielson Robert DBA Conventional Air · Decatur, MIBuilt 1954 · S/N 183547 N20823American Patrols Inc · Midland, TXBuilt 1974 · S/N 17263848 N20825Sussman Stanley M · New Castle, DEBuilt 1974 · S/N 17263849 N20826Lc Aviation LLC · Mocksville, NCBuilt 2004 · S/N 0182 N2082HWalker John R · Spring, TXS/N 20-0045 N20830Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12580 N20834Climb Maintain LLC · Morrisville, MOBuilt 1974 · S/N 17263850 N20837Mjm Enterprise Holdings LLC · Drexel, MOBuilt 1974 · S/N 17263851 N2083DSale Reported · Crystal, MNSale reportedBuilt 1978 · S/N 44-7995126 N2083FDetroit Public Schools Community District · Detroit, MIS/N 17280671 N2083QCardinal N2083q LLC · Churchville, PABuilt 1974 · S/N 177RG0483 N20843St Louis Flying Club Inc · Ellisville, MOBuilt 1974 · S/N 17263853 N20848Lown Jeffrey B II · Shrewsbury, NJBuilt 1979 · S/N 28-7911080 N2084ASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 44-7995081 N2084DWaves4days LLC · El Segundo, CABuilt 2004 · S/N SRG061 N2084EBuchholz Steve DBA · Clarkston, MIBuilt 1978 · S/N 17271148 N2084PSchalk Bretta J · Fountain Run, KYBuilt 1956 · S/N 23-672 N2084THeiss Bryan G · Shelby, MIBuilt 1970 · S/N 28R-7135028 N20858Vintage Flyers Inc · Napa, CABuilt 1974 · S/N 17263857 N2085POphelia Aviation LLC · Paradise Valley, AZBuilt 1979 · S/N 28-7911102 N2085TBlue Skies Aircraft LLC · Kalispell, MTS/N 28R-7135029

Back to AD 81-18-04 R2