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.

N1404CAeroscalper LLC · Goshen, INBuilt 1977 · S/N 17702721 N1404PGreen Rose LLC · Swartz Creek, MIBuilt 1986 · S/N 42 N14050M & K Flying Service Inc · Hot Springs Vill, ARBuilt 1975 · S/N 857-75 N14059Withrow James R Jr · Crawley, WVBuilt 1987 · S/N 185 N1405CGbq LLC · New Prague, MNBuilt 1953 · S/N 22-1162 N1405UGuardian Aerial Patrol LLC · Edmond, OKBuilt 1976 · S/N 17267075 N1405XRij Edward · Clovis, CABuilt 1975 · S/N 28-7515292 N14060Skinner Daniel R · Mount Airy, GABuilt 1964 · S/N 28-20333 N14064University Of Central Missouri · Warrensburg, MOBuilt 1972 · S/N 18-8989 N1406CMcaninch Danny Ray · Pleasant Hill, CABuilt 1977 · S/N 17702722 N1406RPatrick Ernest E · Lufkin, TXBuilt 1974 · S/N AA1B-0506 N1406TCitabria Inc · Auburn, CABuilt 1972 · S/N 28R-7235280 N14078Tundra Aviation Inc · Casselton, NDS/N 27-4679 N1407CLafreniere Joseph A · Harmony, MNBuilt 1953 · S/N 22-1157 N1407DFlight Training Aircraft LLC · Wilmington, DEBuilt 2008 · S/N 172S10666 N1407JInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 407 N1407TAndrews University · Berrien Springs, MIBuilt 1972 · S/N 34-7250311 N1407UN R I Flying Club · Walnut Creek, CABuilt 1976 · S/N 17267077 N1407WYoder Sylvan R · Camilla, GAS/N 60382 N1407XRavotti Air LLC · Leechburg, PABuilt 1975 · S/N 28-7505224 N14089Szymanski Tadeusz · Fort Myers, FLS/N 27-4687 N1408BIasco Flight Training Inc · Redding, CABuilt 2006 · S/N 172S10429 N1408CHaworth Michael R · Riverside, CABuilt 1977 · S/N 17702723 N1408JRossi Scott J · Hallsville, TXBuilt 1975 · S/N 408 N1408TCarter Jeff · Paragould, ARS/N 28-7225505 N1409RJersey Boys LLC · Rockledge, FLBuilt 1974 · S/N AA1B-0509 N1409TAnker Mark W · Cambridge, OHBuilt 1972 · S/N 28-7225506 N140ACApplebaugh Jeffrey · Mechanicsville, MDBuilt 1968 · S/N 28-25001 N140AMSuchko Paul S · Venetia, PAS/N 28-26418 N140BCN504fl LLC · Killeen, TXBuilt 1971 · S/N 28-7125313 N140BKFrauenhoffer Kenneth E · Woodruff, WIBuilt 1975 · S/N 28-7525314 N140BWWeselmann Brian David · Edgewater, FLBuilt 2001 · S/N 2908 N140CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13254 N140CKRegistered aircraftFirst renewal noticeBuilt 1969 · S/N 28-26210 N140CTKollar Aviation LLC · Apollo Beach, FLBuilt 2015 · S/N 18282382 N140DDBe Right Back Aviation LLC · Billings, MTBuilt 1971 · S/N 28-7125145 N140DHVeve Rafael A · Indn Hbr Bch, FLBuilt 2001 · S/N 3RX064 N140ERDaly John F Jr · Simpsonville, SCS/N 1529 N140FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290175 N140FLYocum Stuart J · Kingman, AZBuilt 1971 · S/N 28-7125111 N140FPNorthwoods Air LLC · Orono, MEBuilt 1986 · S/N 17276539 N140GBReel Christen · Leighton, ALBuilt 1967 · S/N 28 23806 N140HACarros Dale A · Cape Charles, VABuilt 1968 · S/N 28-25354 N140HCMurphy David B · Germantown, MDBuilt 1969 · S/N 28-25436 N140JAWhitney Lydia Mae · North Charleston, SCBuilt 1982 · S/N 140 N140JFMeriden Aviation Center LLC · Meriden, CTBuilt 1973 · S/N 28-7325416 N140JGBarros Vincent · Kissimmee, FLBuilt 1974 · S/N 32-7400043 N140JNMfd Aviation Inc · Middletown, DEBuilt 1973 · S/N 28-7325244 N140KW47 North Aviation LLC DBA · Wenatchee, WAS/N 28-7625121 N140LRutten Paul J · Pine Island, MNBuilt 1967 · S/N 28-23057

Back to AD 81-18-04 R2