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.

N4494JAldrich Matthew H · Corinth, TXBuilt 1967 · S/N 28-22913 N4494PSimon Mitchell B · Edison, NJBuilt 1961 · S/N 23-2016 N4494YBegrow Adroaldo D · Gulf Shores, ALBuilt 1966 · S/N 25-4161 N4494ZKasemodel Alan D · Billings, MTBuilt 1969 · S/N 18-8848 N4495FKitty Tango LLC · Saint Petersburg, FLBuilt 1976 · S/N 28-7790034 N4495RKohl James D Trustee · Deerfield, ILBuilt 1974 · S/N 17263237 N4495YMerlin Soaring Association Inc · Amelia Court House, VABuilt 1966 · S/N 25-4162 N4495ZDolfi Rick · Sutton, AKBuilt 1969 · S/N 18-8850 N44960Falcon Aviation · Clarence Center, NYBuilt 1977 · S/N 28-7890044 N4496JOzdogan Brent · Lawrenceville, NJBuilt 1967 · S/N 28-22915 N4496PPerez Amaro Angel L · Arecibo, PRBuilt 1960 · S/N 232011 N4496XJennings Matthew · Valley Center, CAS/N 28-7690022 N4496YHill Kenneth G · Pocatello, IDBuilt 1966 · S/N 25-4166 N4496ZBarnes Rodney L · Mayville, WIBuilt 1969 · S/N 18-8851 N44974Fort Guerian · Alachua, FLBuilt 1977 · S/N 28-7816051 N44979Archer II Corporation · Marietta, GABuilt 1977 · S/N 28-7890045 N4497AMorris Duane E · Wasilla, AKBuilt 1956 · S/N 18-4869 N4497FMurray David J · Waymart, PABuilt 1976 · S/N 28R-7635412 N4497JStewarts Aircraft Service · Waynesville, OHBuilt 1967 · S/N 28-22916 N4497PMatthews Aviation LLC · Hardinsburg, KYBuilt 1961 · S/N 23-2020 N4497RMazurek Drew A · New Haven, CTBuilt 1974 · S/N 17263239 N4497TArrow97t Llp · Feeding Hills, MABuilt 1972 · S/N 28R-7235042 N4497XFlight School Inc · Spring, TXBuilt 1975 · S/N 28-7690023 N4498Miller Gregory L · Loudonville, OHS/N 277 N4498JHartshorn James · Las Vegas, NVBuilt 1967 · S/N 28-22919 N4498TCunniff Jack S · Weymouth, MAFirst renewal noticeBuilt 1972 · S/N 28R-7235045 N4499Southern Utah University · Cedar City, UTBuilt 2020 · S/N 14430 N44990Fineran James V III · Towson, MDBuilt 1977 · S/N 32-7840002 N44996Executive Flyers Inc · Sacramento, CABuilt 1977 · S/N 28-7816054 N4499JWiblemo Craig B · Fallbrook, CABuilt 1967 · S/N 28-22920 N4499PTls Aviation · Marysville, WABuilt 1961 · S/N 23-2022 N4499WUrban James R · Pierre, SDBuilt 1965 · S/N 28-2911 N449AArcher Aero LLC · Wilmington, DEBuilt 2014 · S/N 2843798 N449AGKershner Jordan · Malcolm, NEBuilt 1967 · S/N 17700344 N449AK3 Danes And A Moose LLC · Granada Hills, CABuilt 2023 · S/N 3412 N449ASConcho Aviation LLC · Sterling City, TXBuilt 2003 · S/N 10108 N449BASpitzer Helicopter LLC · Woodland Hills, CABuilt 2013 · S/N 2265 N449BCMcbride Richard A · Deer Park, WAFirst renewal noticeBuilt 2007 · S/N 1681 N449BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496608 N449CNSpeedo Air LLC · Hales Location, NHS/N 10431 N449CSHorizon Flight Center LLC · Chesapeake, VABuilt 2017 · S/N 172S12025 N449DAArford Dennis C · Athens, GABuilt 2017 · S/N 22124 N449DMMccord David B · Chico, CABuilt 1998 · S/N 001 N449DYRanjit Pearlinda · Apex, NCBuilt 1972 · S/N 28R7235200 N449EWWilliams Ethan B Trustee · Wasilla, AKBuilt 2012 · S/N 001 N449FAAlba Aviation Services Inc · Scottsdale, AZBuilt 2004 · S/N 3683 N449JGHerlihy John J · Arroyo Grande, CABuilt 1979 · S/N 61P06567963304 N449LMontana Hotel LLC · Providence, UTBuilt 1993 · S/N 2075 N449MKNorth Star Aviation · Mankato, MNBuilt 2022 · S/N 4496534 N449PAChristiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 4496185

Back to AD 81-18-04 R2