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.

N328DGGoodwin David Carl IV · Boulder, WYBuilt 1999 · S/N 001 N328DHBrown Kevin E · Rosamond, CABuilt 2004 · S/N BV001 N328ESisson J P · Litchfield, ILBuilt 2004 · S/N 20762 N328FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13220 N328GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881115 N328JMGrand Aviation Inc · Grove, OKS/N 2082 N328LPNice Volmer LLC · Toledo, OHBuilt 1969 · S/N WJBC-1-1-67 N328MDJames Douglas M Trustee · Scottsdale, AZBuilt 1995 · S/N 758-95 N328MEFlying Start Aero Services LLC · Reno, NVS/N 172S8575 N328NCHenderson Anthony B · Hoschton, GABuilt 1977 · S/N 28R-7737164 N328SGUp Lights LLC · Jacksonville, FLBuilt 2013 · S/N 1 N328SSUnited Helicopter Leasing LLC · Honolulu, HIBuilt 2002 · S/N 1214 N328TASuburban Air Corp · Castro Valley, CABuilt 2003 · S/N 172S9328 N328TRRufi Craig · Thousand Oaks, CABuilt 2019 · S/N 40555 N32903Foxtail Aviation LLC · Orefield, PABuilt 1974 · S/N 28-7515271 N32904Sheidler Randy L · Gallipolis, OHBuilt 1974 · S/N 28-7515272 N32906Benson Brian R · Mauston, WIBuilt 1974 · S/N 28-7515273 N3290MMullins Esten R · El Paso, TXBuilt 1947 · S/N 12-2151 N3290QCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1977 · S/N 28-7716147 N3291EKukuchka Ronald G · Tunkhannock, PABuilt 1978 · S/N 17271493 N3291FEvans Derek M · Fresno, CABuilt 1967 · S/N 670384 N3292FGoodwin Darrell W · Richmond, TXBuilt 1967 · S/N 670385 N3292PCrosswindz Ranch LLC · Seminole, TXS/N 23-1242 N3292TCelestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1967 · S/N 17700592 N3292WOldenkamp Daryl · Hermosa Beach, CAS/N 32-125 N3292ZAlbertson James M · Westville, FLBuilt 1959 · S/N 18-7229 N32932Gilbert Roy S · Mechanicsville, VABuilt 1974 · S/N 28-7515276 N3293BHuttunen Alice D Trustee · Wasilla, AKBuilt 1954 · S/N 18-3287 N3293FYe Xiaofeng · Los Gatos, CABuilt 1968 · S/N 680001 N3293QRegistration Pending · Gainesville, TXRegistration pendingBuilt 1977 · S/N 28-7790447 N3293RBrook Jacob C · Broken Arrow, OKBuilt 1969 · S/N 28R-31264 N3293VMckinney Brian · Lakeville, MNBuilt 1995 · S/N 80 N3293ZStraight And Leve Aeromedical LLC · Billings, MTS/N 18-7230 N32942Bent James L Jr DBA · Palatine Bridge, NYS/N 18-7231 N32947Alpe Holding LLC · Van Nuys, CABuilt 1974 · S/N 28-7515279 N3294BSylvester Robin R · Soldotna, AKBuilt 1954 · S/N 18-3292 N3294CNorwood Kent L · Springfield, MOBuilt 2015 · S/N 90649 N3294FWatkins Grant M · Durant, OKBuilt 1967 · S/N 670387 N3294MLorenzo Jennifer A · Meridian, IDBuilt 1947 · S/N 12-2142 N3294RMurray Dennis P · Malta, NYBuilt 1969 · S/N 28R-31265 N3294TWolniansky Peter W · Ocean Grove, NJS/N 17700594 N32956Meritt Kendall E · Wayne City, ILBuilt 1974 · S/N 28-7510035 N3295MParamount Air Service · Rio Grande, NJBuilt 1947 · S/N 12-2143 N3295WChapman Daniel H Jr · Ontario, CABuilt 1965 · S/N 32-128 N32969Henry Robert K · Knoxville, TNBuilt 1974 · S/N 28-7515282 N3296BCommand-Aire LLC · Coatesville, PABuilt 2000 · S/N 14673 N32971Umbdenstock Jerry R · Thermopolis, WYBuilt 1974 · S/N 28-7505106 N32978Klippel Charlie L · Huntington Beach, CABuilt 1975 · S/N 28R-7535103 N3297BStevens Lance R · Kennewick, WAS/N 18-3299 N3297FCadillac Aircraft Services Inc · Cadillac, MIBuilt 1967 · S/N 670390

Back to AD 81-18-04 R2