Registered aircraft · 81,733

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.

N51789Breyer Charles A · Lewes, DEBuilt 1978 · S/N 454-2 N5178AHale Mitchell D · Chugiak, AKBuilt 1962 · S/N 18-7483 N5178HGage Scott M · Anchorage, AKS/N 14-200 N5178LMinick And Son LLC · Beatrice, NEBuilt 1967 · S/N 28-4464 N5178RHampton Flying Services LLC · Portsmouth, NHBuilt 1974 · S/N 17263395 N5178SG & M Aircraft Inc · Wheat Ridge, COBuilt 2002 · S/N 17281097 N5178USoutheastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281098 N5178WMahoney Christopher P · Quakertown, PABuilt 1961 · S/N 28-213 N5178ZUnderwood Robert D Jr · Randolph, NYBuilt 1961 · S/N 22-8842 N51790Tartock Russell L · Salisbury, NCBuilt 1979 · S/N AA5A-0850 N51793Lindsey Richard A · Richmond, TXBuilt 1980 · S/N 17274347 N5179HFlight Time Builders Inc · Memphis, TNBuilt 1975 · S/N 17265362 N5179PHangar 17 LLC · Sheridan, WYBuilt 1958 · S/N 24-199 N5179THiggs Kathleen A · Garden Plain, KSBuilt 1967 · S/N 139 N5179VFairmont State University · Fairmont, WVBuilt 1980 · S/N 172RG0460 N5179XKor Reese W · Piedmont, SDBuilt 1969 · S/N 189 N517APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843753 N517AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2021 · S/N 28020046 N517ATHodgson Christopher John · Santa Cruz, CABuilt 2017 · S/N 41237 N517BWWomer Blaine A · Hemet, CABuilt 2007 · S/N 2843652 N517DLDelta Leema Aviation LLC · Moncks Corner, SCBuilt 1977 · S/N 17268965 N517GSPtag Flight Service LLC · Vidalia, GABuilt 1996 · S/N 2996 N517HHart James A · Arlington, VABuilt 2021 · S/N 42219 N517HWVogt Chancey · Becida, MNBuilt 2023 · S/N JA1308077 N517JGollus Daniel T · Lockport, NYBuilt 1997 · S/N 22753 N517JCProfessional Pilot Services · Appleton, WIBuilt 1971 · S/N 28-7125098 N517KBCorkins William J · Auburndale, FLBuilt 2025 · S/N 3300 N517LBuchenroth Steven L · Huntsville, OHFirst renewal noticeBuilt 1969 · S/N BP1 N517LEWestern Warbirds LLC · Prescott, AZBuilt 2011 · S/N 001 N517MAKilo Charlie Aeronautics LLC · Baton Rouge, LABuilt 2017 · S/N 18283007 N517MMMiller Jeremy M · Hazle Township, PABuilt 1978 · S/N 32R-7885191 N517MSJewett John G · Ellensburg, WABuilt 1978 · S/N R18200681 N517RLAndrews Mimi M · Hilltop Lakes, TXBuilt 1996 · S/N 22626 N517RSGraham Konner T · Pittsburg, TXBuilt 1998 · S/N 21117 N517SCSpartan Education LLC · Tulsa, OKBuilt 2019 · S/N 2881264 N517SHHelme Stanley B · Lodi, CABuilt 2003 · S/N 70624 N517SMMcelvain Pete R · Iowa Park, TXBuilt 1968 · S/N 17257318 N517TPAerotrust Services Corp Trustee · Wilmington, DEBuilt 2019 · S/N XL 275 N517VBBoudro Vernon G · Greenview, CABuilt 2008 · S/N 70216 N517WCFreedom Wings LLC · Parker, COBuilt 1993 · S/N 1809065 N517WDAmundson Lee R · Chatfield, MNBuilt 2021 · S/N 02210164 N51804Summit Aviation Inc · Belgrade, MTBuilt 2009 · S/N 172S10898 N5180BRoberts Toney K · Batesville, MSS/N 6-6833 N5180LGrogan Timothy · Bradenton, FLBuilt 1967 · S/N 28-4466 N5180PN5180p LLC · Willow Springs, MOBuilt 1958 · S/N 24-201 N5180RMacdonald Kaitlyn · Dillon, MTS/N 17263397 N5180XSouthern Sky Holdings LLC · Macon, GABuilt 1969 · S/N 190 N5180ZScheer Paul G · Portland, ORBuilt 1961 · S/N 22-8846 N51810Jones David L · Powderly, TXS/N 224 N51816Barr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281120

Back to AD 81-18-04 R2