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.

N4936ZDomeyer Daylen K · Cincinnati, OHS/N 22-8528 N49370Powell Weston G · Washoe Valley, NVBuilt 1994 · S/N 1273 N49371Hebert Max C · Hartstown, PABuilt 1995 · S/N 1277 N49372Walker Scott E · Fort Collins, COBuilt 1995 · S/N 1284 N4937FRegistered aircraftBuilt 1976 · S/N 28-7790075 N4937GInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 17273484 N4937PMorcom Aviation Services Inc · Everett, WABuilt 1981 · S/N 15284849 N4937SRauch James A III · Cayce, SCBuilt 1980 · S/N R18201476 N4937TSalsbery Enterprises Inc · Sharpsville, INBuilt 1981 · S/N R18201795 N49387Old Aire LLC · Bellingham, WAS/N 5-1493 N4938HAir Poueir LLC · Amarillo, TXBuilt 1979 · S/N 15284033 N4938TTilney Five LLC · Belleair, FLBuilt 1981 · S/N R18201796 N4938YAerial Banners Inc · Pembroke Pines, FLBuilt 1968 · S/N 25-4738 N4939LNorcross Tracy D · Saint Joseph, MOBuilt 1967 · S/N 28-4309 N4939SLeriche Daniel R · Wolcott, VTBuilt 1980 · S/N R18201478 N4939VFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1980 · S/N 172RG0420 N493BTRegistration Pending · Deltona, FLRegistration pendingBuilt 1975 · S/N 17702318 N493CAMccann James M · Ennis, MTBuilt 1967 · S/N 32-346 N493CKTaylor Mark Steven · Goshen, OHBuilt 2012 · S/N 493 N493CPCivil Air Patrol · Maxwell Afb, ALBuilt 2010 · S/N 18282265 N493DSDelaware State University · Dover, DEBuilt 1983 · S/N 28-8416011 N493DWWayman Daniel M · Medford, ORBuilt 2005 · S/N 126 N493EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12260 N493FLPalmenteri Louis J · Rhome, TXS/N 28-7125308 N493GCClayton Neil K · Oviedo, FLFirst renewal noticeBuilt 2007 · S/N 493 N493JLPhoenix Flyers Inc · Mesa, AZBuilt 1998 · S/N 18280138 N493JPRadtke Michael K · Mesilla, NMBuilt 2006 · S/N 2004 N493MAGreat Planes Aviation Inc · Rochester, MNBuilt 2001 · S/N 2843486 N493RMRaritan Valley Flying School · Princeton, NJBuilt 1999 · S/N 17280784 N493SHForsman David G Co-Trustee · South Haven, MNBuilt 1968 · S/N 17256881 N49404Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1977 · S/N 15281240 N4940EFlyright Aviation Inc · North Las Vegas, NVBuilt 1978 · S/N 17271681 N4940FJackson Christopher M · Clearwater, FLBuilt 1976 · S/N 28R-7635445 N4940GN4940g LLC · Portsmouth, NHS/N 17273487 N4940LDrown William K · Columbus, OHS/N 28-4310 N4940PArpey Aviation Ltd · Colleyville, TXBuilt 1963 · S/N 27-535 N4940SO'Gorman Robert W Jr · Wake Forest, NCBuilt 1980 · S/N R18201479 N4940UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842228 N4940WKitt Consulting LLC · Boardman, OHBuilt 1977 · S/N 14262 N49417Rich John E · Dunnellon, FLS/N 15281248 N49419Ds Flight Services LLC · Battle Ground, WAS/N 15281250 N49423Johnson Shem E · Bonners Ferry, IDBuilt 1978 · S/N 15281254 N49424Xin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 15281255 N4942HFlorida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1979 · S/N 15284036 N4942PSchulz Beverly A · Merrill, WIBuilt 1963 · S/N 27-537 N49434943 LLC · Kalispell, MTBuilt 2014 · S/N 4311 N49432Northshore Group LLC · Wilmington, DEBuilt 1978 · S/N 15281262 N49434California In Nice Inc · San Jose, CABuilt 1979 · S/N 15283458 N49438Crickmer Charles C · Overton, NVBuilt 1978 · S/N 15281267 N49439Wisconsin Aviation Four Lakes Inc · Madison, WIBuilt 1978 · S/N 15281268

Back to AD 81-18-04 R2