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.

N428EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2014 · S/N 172S11451 N428FClark Robert D · Bedford, NHBuilt 1969 · S/N 28R-35201 N428FFDhs Operations LLC · Wilmington, DEBuilt 2004 · S/N 17281228 N428HCNott Terry · Overland Park, KSBuilt 1979 · S/N 15283916 N428JGDr Rotors LLC · Mccall, IDBuilt 2003 · S/N 10168 N428JPCal Aircraft LLC · Lewes, DEBuilt 2004 · S/N 40.426 N428JSHoerr Stacy D · Taylor, MOBuilt 1993 · S/N 101 N428KWKangas Matthew S · Santa Cruz, CABuilt 1998 · S/N 24486 N428LBMam Aviation LLC · New York, NYBuilt 2006 · S/N 18281813 N428MRepanshek David J · Hertford, NCBuilt 1979 · S/N 28-8090169 N428MTNby Productions · Manassas, VABuilt 2010 · S/N 18282234 N428NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010014 N428PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843476 N428PBVander Molen William L · Hudsonville, MIBuilt 2017 · S/N 6 N428RHegy Thomas R · Hartford, WIBuilt 1971 · S/N 244-H N428RBHouser Blue D · Edgemoor, SCBuilt 1963 · S/N 128 N428RGGandolfo Air LLC · Watertown, CTBuilt 1973 · S/N 17262092 N428RVCunningham Gary R II · Satellite Beach, FLBuilt 2014 · S/N 40303 N428SGriffing Flying Service Inc · Port Clinton, OHBuilt 1980 · S/N 32-8106021 N428SPStar Flight LLC · Johns Creek, GABuilt 2003 · S/N 40.283 N428SXMann John Franklin Jr · Marietta, GABuilt 2014 · S/N 001 N428WAPhillips Jeffry T · Ellensburg, WABuilt 1989 · S/N BIERMAN 0001 N428WREagle Flying Club Of Embry-Riddle Aeronautical Unv · Daytona Beach, FLBuilt 2005 · S/N 172S10058 N4290EAnderson Todd R · Bremerton, WABuilt 1978 · S/N 38-78A0532 N4290HOwen Toy C · Anchorage, AKS/N 14-94 N4290ZShearer John W · The Dalles, ORBuilt 1967 · S/N 18-8539 N42917Afmr Inc · Dover, DEBuilt 1991 · S/N 2691 N4291HDuclos Jack B · Anchorage, AKBuilt 1949 · S/N 14-95 N4291JImai Benjamin T · Silverado, CABuilt 1967 · S/N 28-22656 N4291SHobart Aviation Inc · Akron, OHBuilt 1982 · S/N 28-8316036 N4292Cppetersonrvtoys LLC · Lander, WYS/N 131 N42920Sanders Craig A · Stockton, CABuilt 2006 · S/N 5762 N42927Strickland Albert L · Capitola, CABuilt 1974 · S/N 28-7415406 N4292HRoss Peter W Trustee · Lufkin, TXBuilt 1948 · S/N 14-45 N4292JReds Aircraft LLC · Edinburg, TXBuilt 1967 · S/N 28-22660 N4292MNelson Kenneth W · Duluth, MNBuilt 1947 · S/N 12-3223 N4292QSky Walker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17260192 N4292YWalters Jason · Palm Springs, CABuilt 1983 · S/N 28-8390037 N4293HHelleberg John R · Centreville, VABuilt 1978 · S/N 24-0697 N4293JCoastal Virginia Aviation LLC · Chesapeake, VABuilt 1967 · S/N 28-22661 N4293QKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1971 · S/N 17260193 N4293YArcher N4293y LLC · Tulsa, OKBuilt 1983 · S/N 28-8390040 N4293ZSuper Cub N4293z LLC · Creston, CABuilt 1967 · S/N 18-8603 N42942Mott Plane LLC · Morning Sun, IABuilt 1983 · S/N 32-8306018 N42945Pollnow Dean M · West Bend, WIBuilt 1983 · S/N 32-8306020 N4294JWahner Rudolf M Jr Trustee · Aston, PAS/N 28-22663 N4294MBreiner Joyce K · Poolesville, MDBuilt 1947 · S/N 12-3225 N4294NCoastal Aviation LLC · Virginia Beach, VABuilt 1983 · S/N 32R-8313011 N4294QOptimized Aviation Services LLC · Huntington Station, NYS/N 17260194 N4294TSopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1971 · S/N 28-7205134

Back to AD 81-18-04 R2