Registered aircraft · 81,720

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.

N21TAerostar Marketing Group LLC · Nicholasville, KYBuilt 1981 · S/N 61P08328163440 N21TFFirdaus Tahir · Girard, OHBuilt 1990 · S/N 72 N21TRCareer Aviation Company Inc · Wilmington, DEBuilt 2023 · S/N 28020116 N21VGHarris Kenneth L · Greeley, COBuilt 1980 · S/N VAC16080 N21VXSisco Avery · Amarillo, TXBuilt 1982 · S/N 345 N21WCAquino Richard J · Westfield, INBuilt 1974 · S/N 76 N21WKKing Wesley A · Los Angeles, CABuilt 2004 · S/N 001 N21WVHowell Jeffrey · Tehachapi, CABuilt 1992 · S/N 02 N21WYRegistered aircraftBuilt 2012 · S/N 3171 N21WZPlumb Ray A · Salida, COBuilt 2000 · S/N 2637 N21XGPrivitt Bret · Hudson Oaks, TXBuilt 1982 · S/N 1007 N21XLMilligan Edward · Beaverton, ORS/N 1000 N2200JOld Prairie Products Inc · Angola, INBuilt 1979 · S/N 32R7985041 N2200SPa32 Aviation LLC · Blue Bell, PABuilt 1979 · S/N 32-7940055 N2200YBarber Aviation LLC · Wilmington, DEBuilt 1979 · S/N 28-7911146 N2201AJulius Air LLC · Lewes, DEBuilt 1978 · S/N 24-0559 N2201MSteck Richard E · Arlington Heights, ILBuilt 1978 · S/N 24-0560 N2201PRm Stoudt Inc · Jamestown, NDBuilt 1978 · S/N 24-0561 N2201QBocaj Air LLC · Irving, TXBuilt 1978 · S/N 24-0562 N2201RMize Helicopter LLC · Grand Prairie, TXBuilt 1978 · S/N 24-0564 N2201TCiupitu Marc P · Houston, TXBuilt 1971 · S/N 28-7105182 N2201YInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 17700001 N2202AArtisan Aviation Inc · Rochester, NYBuilt 1978 · S/N 28-7916102 N2202BRegistration Pending · George West, TXRegistration pendingS/N 6629 N2202PMacair Aviation LLC · Xenia, OHBuilt 1956 · S/N 23-812 N2202QLewis University · Romeoville, ILBuilt 2007 · S/N 172S10517 N2202TColeman Shawn P · Ontario, ORBuilt 1987 · S/N 2202 N2202UAsp Legacy Holdings Corp · SpringwaterBuilt 1979 · S/N 32-7940061 N2202WMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-7916332 N2202YStanley Aviation LLC · Colby, KSS/N 28-7911147 N2202ZHazlewood Norman R · Wichita, KSBuilt 1981 · S/N 28-8116278 N22034Robertson David L · Ray, MIBuilt 1974 · S/N 17264052 N2203ASs Three LLC · North Platte, NEBuilt 1978 · S/N 28-7990111 N2203DWhytes Inc · Coconut Creek, FLBuilt 1978 · S/N 28-7916148 N2203FElk Flyers Inc · Saint Marys, PABuilt 1978 · S/N 28-7990191 N2203MLane Aviation Academy · Eugene, ORBuilt 1977 · S/N 28-7816258 N2203POne More Time Aviation Inc · Bossier City, LABuilt 1956 · S/N 23-813 N2203RHubin Scott E · Kent, OHBuilt 1975 · S/N AA5B-0071 N2203TGateway Flight Training LLC · Saint Louis, MOBuilt 1979 · S/N 28-7916300 N2203VSnyder Jeffrey L · Annapolis, MDBuilt 1979 · S/N 28-7916326 N22044182 Flight Corp · Bronx, NYBuilt 2005 · S/N 18281671 N2204ATbl Aviation LLC · Meridian, IDBuilt 1978 · S/N 28-7911006 N2204DOvercast Dan · Columbia City, ORBuilt 1978 · S/N 28-7916149 N2204TNgugi Samson W · El Paso, TXBuilt 1971 · S/N 28R-7135168 N2204ULi'L Dawg Aviation Inc · Florence, ALBuilt 1979 · S/N 32-7940065 N2204XAirgo Inc · Centralia, ILBuilt 1979 · S/N 44-7995281 N2204YEagle Sky Patrol Inc · Deadwood, SDS/N 17700004 N22055Adrian Ojeda Jr · San Ysidro, CAS/N 17280902 N2205ARiggin Flight Service Inc · Madison, SDBuilt 1952 · S/N 18-1881 N2205FMolzon William R · Irvine, CABuilt 1978 · S/N 28-7911049

Back to AD 81-18-04 R2