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.

N47193Cloud Dancer Aviation Inc · Deland, FLBuilt 1979 · S/N 15283185 N4719AAvquest Aviation Services LLC · Montgomery, NYBuilt 1956 · S/N 18-4939 N4719FFrederick Joel · Hobe Sound, FLBuilt 1979 · S/N 17273076 N4719LMinderman David J · Westlake, OHBuilt 1967 · S/N 28-4039 N471AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843743 N471ACWard Allen M · Andalusia, ALBuilt 1998 · S/N 410-98 N471AKAkima Logistics Services LLC · Usaf Academy, COBuilt 2018 · S/N CC18-0090 N471AMWells Alex E · Bend, ORBuilt 2004 · S/N 2271 N471ATAirmen Testing & Training Inc · Lantana, FLBuilt 1987 · S/N 0737 N471DBBridgham David A · Plainfield, NHBuilt 2015 · S/N 013 N471DLSutton Douglas A · Paola, KSBuilt 1964 · S/N 28-10384 N471EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2018 · S/N 172S12193 N471FJForeman Frank A · Call, TXBuilt 2011 · S/N 72325 N471GMHarland Willard G · Tuscumbia, ALBuilt 1979 · S/N R18201112 N471HCHinds Community College · Raymond, MSBuilt 2024 · S/N 28020199 N471JROrtiz Rivera Jose E · Bayamon, PRBuilt 1972 · S/N 17260933 N471KWheeler M Andrew · Westfield, INBuilt 2002 · S/N 471A N471MHHughes Michael J · Mayville, WIBuilt 2020 · S/N 767 N471MRAdvanced Aviation Group LLC · Frederick, MDS/N 17281078 N471NPGallant David A · Hartsel, COBuilt 1999 · S/N 22471 N471PRRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1973 · S/N 17262016 N471SPPine Ventures LLC · Malmo, NEBuilt 1998 · S/N 172S8014 N471TMAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13471 N471VVlieg Roger W · Marianna, FLBuilt 1966 · S/N 28-10844 N47204Reinhardt Michael J · Tonawanda, NYBuilt 1977 · S/N 1499 N4720AP P & J LLC · Gillette, WYBuilt 1956 · S/N 18-4941 N4720BAffiliated Air Services Inc · Vincentown, NJBuilt 1979 · S/N 15283596 N4720FBennett Ronald W · North Pole, AKBuilt 1963 · S/N 18-7989 N4720RHotkeys Holding LLC · Silver Spring, MDBuilt 1979 · S/N 172RG0016 N4721BEuro 2000 Inc · Merritt Island, FLBuilt 1979 · S/N 15283597 N4721LLee Christopher S Sr · Quinton, VABuilt 1967 · S/N 28-4043 N4721RWaterdawg Express LLC · Pocatello, IDBuilt 1979 · S/N 172RG0017 N47225Aviation Partners Inc · Carson City, NVBuilt 1977 · S/N 28-7890050 N47227N47227 Inc · Hobe Sound, FLBuilt 1977 · S/N 28R-7737158 N4722AJoos Devon T · Menlo Park, CABuilt 1956 · S/N 18-4943 N4722PEac Property Management LLC · Atlanta, GAS/N 240245 N4722SStallman Jon · Chico, CABuilt 1996 · S/N 002 N4722YX-C Soaring Association Inc · Pensacola, FLBuilt 1967 · S/N 25-4465 N47232Lensis Thomas M · Wilmington, NCBuilt 1977 · S/N 32R-7880001 N4723BEuro 2000 Inc · Merritt Island, FLBuilt 1979 · S/N 15283598 N4723PChristiansen Aviation LLC · Wilmington, DEBuilt 1980 · S/N 15284804 N4723RSmolkin Alexander S · North Chesterfield, VABuilt 1979 · S/N 172RG0018 N4723TPrs Holdings Inc · Jurupa Valley, CABuilt 1981 · S/N R18201744 N4723ZMartin William S · S Coffeyville, OKBuilt 1961 · S/N 22-8268 N4724JRegistration Pending · Orlando, FLRegistration pendingS/N MB-184 N4724PTnt Farms · Marana, AZS/N 27-252 N47253De Wan Madisun Nicole · Tarpon Springs, FLBuilt 1979 · S/N 15283198 N4725DClover Park Technical College · Tacoma, WABuilt 1979 · S/N 17272340 N47261Future American Aviators LLC · Davie, FLS/N 15283204 N47268Jones Benn D · Bell, FLBuilt 1979 · S/N 15283206

Back to AD 81-18-04 R2