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.

N41383Lamontagne Bradley Theodore Jr · Pleasant View, TNBuilt 1974 · S/N 28-7425232 N41387Horizon Aviation LLC · Brooks, GABuilt 1972 · S/N 28-7225198 N41389Johnson David C · Chisago City, MNBuilt 1974 · S/N 28-7415197 N4138GUtah State University · Logan, UTBuilt 2008 · S/N 4275 N4138HMiller John A · Ballston Lake, NYBuilt 1978 · S/N 24-0643 N4138JRegistration Pending · Orlando, FLRegistration pendingBuilt 1966 · S/N 28-22461 N4138PFreyburger Gregory P · Strykersville, NYBuilt 1959 · S/N 23-1619 N4138QSteward John A · Atlanta, GABuilt 1999 · S/N 3246139 N4138XBroadwell Eric B · Woodstock, GABuilt 1968 · S/N 238 N4138ZZweifel Douglas L · Anchorage, AKS/N 18-8210 N41391Aurora Aviation Lc · Pierce City, MOBuilt 1974 · S/N 28R-7435177 N41395Vera Aviation LLC · Mountain Home, IDBuilt 2008 · S/N 4379 N41399Beck Paul R · Knoxville, IABuilt 1974 · S/N 28-7415199 N4139JWolles Joseph · Dell Rapids, SDBuilt 1966 · S/N 28-22463 N4139MWhiteley Jeffrey L · Jefferson, ORS/N 12-3038 N4139RPilot Mountain Aviation LLC · Pilot Mountain, NCBuilt 1999 · S/N 3246130 N4139YPremier Management Co Inc · Mobridge, SDBuilt 1978 · S/N 1248-78 N4139ZL Sheffels And Son Inc · Wilbur, WABuilt 1965 · S/N 18-8211 N413AAAmerican Aviation Inc · Brooksville, FLBuilt 2000 · S/N 172S8413 N413ABBaxter Thomas L · Stockbridge, GABuilt 2011 · S/N 01 N413AMCosmic Kid LLC · Alpine, WYBuilt 2007 · S/N 2413 N413BBRegistration Pending · Iron Station, NCRegistration pendingBuilt 1997 · S/N 23432 N413BSSpeck Enterprises LLC · Missoula, MTBuilt 2013 · S/N 40955 N413BXAlbrecht Devin C · Shavertown, PABuilt 1989 · S/N 22 N413CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13239 N413CCMikkelsen Timothy O · Wasilla, AKBuilt 2013 · S/N CC18-0065 N413CSGolf Romeo Charlie LLC · Elk Grove, CABuilt 2016 · S/N 18282413 N413DBEstelle Karsen · Mc Neal, AZBuilt 2003 · S/N 1299 N413DPYale Companies LLC DBA · Fishers, INBuilt 2006 · S/N 4496234 N413EBG&M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 172RG0113 N413EFIsland Aviation LLC · East Greenwich, RIBuilt 1974 · S/N 28R-7435173 N413EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12640 N413JSClearwake Inc · Kaysville, UTBuilt 1984 · S/N 8042-C N413KTAce Tomato Company LLC · Mcgregor, TXBuilt 2005 · S/N 2843608 N413LHRatcliff Dustin Matthew · Saltville, VABuilt 2008 · S/N S1925 N413LMRba LLC · Kimberly, IDBuilt 2007 · S/N 60396 N413MASterling Flight Training LLC · Jacksonville, FLBuilt 1976 · S/N 17267164 N413MFRegistered aircraftBuilt 2015 · S/N 18282412 N413NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010006 N413RBLarson Cody Q · Dillingham, AKBuilt 2003 · S/N 413R N413RDDos Amigos Air Service LLC · Carrizo Springs, TXBuilt 2004 · S/N 18281464 N413THPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020252 N413WCBradshaw Larry C · Edgewood, TXBuilt 2009 · S/N 91607 N413WPKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1999 · S/N 1261-99 N413YKGoodner Terry Jack · Port Saint Lucie, FLS/N 818 N413ZPPettinger Tom W · Cody, WYBuilt 2004 · S/N 8-4705 N41402Isofly LLC · Canyon Country, CABuilt 2008 · S/N 1934 N4140JStone Raymond M · Moore, OKBuilt 1966 · S/N 28-22464 N4140PRenda Gregory L · Saratoga, CABuilt 1999 · S/N 21064C N4140WBird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843228

Back to AD 81-18-04 R2