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.

N512ACBuck James Kyle III · Oak Ridge, NCBuilt 1999 · S/N 1281-99 N512AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2021 · S/N 28020043 N512AUCunningham Argus I · Liberty Hill, TXBuilt 1983 · S/N H4113SD N512BLawler Glenn M · Mooresville, NCBuilt 1999 · S/N 2308 N512BWMontauk Catamaran Co LLC · Montauk, NYBuilt 1974 · S/N AA5-0702 N512CTCoast Flight Training And Management Inc · San Diego, CABuilt 2005 · S/N 17281264 N512FCFlights For Christ · Mount Vernon, ILBuilt 2007 · S/N GA8-07-112 N512FLReiley Allen Ted · Lavernia, TXBuilt 1971 · S/N 28-7125336 N512JHHenson David · Fallon, NVBuilt 2004 · S/N 90468 N512KCJunfer Flyers LLC · Wilmington, DEBuilt 2000 · S/N 9909CC N512LEHelipl LLC · Winter Garden, FLBuilt 2024 · S/N 2774 N512MACurrie George H III · Fleming Island, FLBuilt 1977 · S/N 28-7716224 N512MSTiralongo Sebastiano · Weston, FLBuilt 1992 · S/N 2841349 N512NDCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10763 N512PTHigh Performance Aircraft LLC · El Cajon, CABuilt 1973 · S/N 28-7305101 N512PVWalker John A · Kotzebue, AKS/N 674 N512RHHolloway Harry T (Tal) · Pittsboro, NCBuilt 2019 · S/N 40476 N512RSRollison Michael W · Fairfield, PABuilt 2003 · S/N 001 N512SInternational Air Services Inc Trustee · Carson City, NVS/N 512 N512SPAvolant Aviation LLC · Mooresville, NCBuilt 2000 · S/N 172S8371 N512TFN408dm LLC · Rye, NYBuilt 2022 · S/N 2881593 N512TMSouthern Flight Aviation LLC · Bainbridge, GABuilt 1978 · S/N 17271721 N512VAAb Prop Plane I LLC · Metairie, LABuilt 2024 · S/N 299/US N512WMcm Sports LLC · Hailey, IDS/N 20368 N512WYBrown Malcom · Bedford, WYBuilt 2023 · S/N 3415 N51300Loftin Gabe · Weatherford, TXBuilt 1977 · S/N 177RG1137 N5130EAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 17271725 N5130FC & M Dreamflights LLC · Mount Pleasant, SCBuilt 2002 · S/N 172S9068 N5130HCalkins David Martin · Anchorage, AKBuilt 1949 · S/N 14-141 N5130LSalisbury Gershom · Prescott, AZBuilt 1967 · S/N 28-4413 N5130PWhite Guy B · Waxahachie, TXBuilt 1958 · S/N 24-143 N5130RShamp Jimmy L · Fresno, CABuilt 1974 · S/N 17263347 N5130TInfinity Aviation LLC · Piedmont, SDS/N 76 N5130WMccutcheon Ernest Thomas · Ninety Six, SCBuilt 1961 · S/N 28-157 N5131Registered aircraftBuilt 1966 · S/N GC-1-66 N51313Echo Tango 03 LLC · Anthem, AZBuilt 2001 · S/N 172S9000 N5131EBrunken Barry D · Tower Hill, ILBuilt 1978 · S/N 17271726 N5131LSkipper Up LLC · Herron, MIS/N 28-4414 N5131RMlt Operations LLC · Traverse City, MIBuilt 1974 · S/N 17263348 N5131SForan Dana Francis · Bement, ILS/N 28R-7135158 N5131T3b'S Land Development LLC · Seattle, WAS/N R18201821 N5131VBuswell Aviation Inc · Salem, ORBuilt 1961 · S/N SP27 N5131WArias Timothy R · Tempe, AZBuilt 1961 · S/N 28-158 N5131XWilson Brent S Trustee · Dyer, NVBuilt 1969 · S/N 184 N51325Baldwin Gordon Lee Jr · Altamonte Springs, FLBuilt 2009 · S/N 172S10934 N5132HMohnacs Joseph T · Mount Laurel, NJBuilt 1975 · S/N 17265347 N5132LMongare Job · Athens, TXBuilt 1967 · S/N 28-4415 N5132PMccormick Geoffrey D · Goodyear, AZBuilt 1958 · S/N 24-145 N5132QHauptman Ben · Alexandria, VABuilt 1973 · S/N 17261760 N5132RChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 172S9001

Back to AD 81-18-04 R2