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.

N501ZNorth Georgia Helicopters Inc · Calhoun, GAS/N 18-7836 N50208Haus Jesse M · Fort Worth, TXBuilt 1974 · S/N 17264197 N5020HBorreson Anthony · Mariposa, CABuilt 1975 · S/N 17265303 N5020PThurston Steven C · Salisbury, NCBuilt 1958 · S/N 24-23 N5020RMigliaccio Jason · Palm Bay, FLBuilt 1974 · S/N 17263261 N5020SSchneider Robert R · Fort Benton, MTS/N 28R-35753 N5020TBetlach Christopher Thomas · Kenmore, WABuilt 1972 · S/N 28R-7235175 N5020WAndersen Richard W · Vail, AZBuilt 1961 · S/N 28-21 N5020YStandridge Robert M · Norman, OKS/N 3246187 N5021HAlamo Flyers LLC · Elmendorf, TXBuilt 1975 · S/N 17265304 N5021RWax Sally G · Louisville, KYBuilt 1974 · S/N 17263262 N5021ZFansler Rick L · Delta, OHBuilt 1961 · S/N 22-8636 N5022WHovendick William P · Lander, WYBuilt 1961 · S/N 28-23 N5023JTexas State Technical College · Waco, TXBuilt 2001 · S/N 172S8964 N5023LIsland Hoppers Seaplanes 2 LLC · Orlando, FLBuilt 1971 · S/N 480 N5023RStern Joseph L · Morrow, OHBuilt 1974 · S/N 17263264 N5023SSummit Arrow Adventures LLC · Peyton, COBuilt 1970 · S/N 28R-35759 N5023YAas LLC · Ovid, MIBuilt 1962 · S/N 27-2027 N5023ZBauer Glenn D · Wishram, WABuilt 1961 · S/N 22-8638 N50240Carr James T · Scotts, MIBuilt 1978 · S/N 436-78 N50246Taubman Jason · Greenland, NHBuilt 1978 · S/N 1052-78 N50247Haywood Charles E Jr · Valrico, FLS/N 437-78 N5024PSun Aviation Inc · Santa Clara, CABuilt 1958 · S/N 24-27 N5024SGuy Timothy S · Henderson, NVBuilt 1970 · S/N 28R-35760 N5024TMoore Jason J · Spanish Fort, ALBuilt 1972 · S/N 28-7225320 N50259Coker Steve L III · Tyler, TXBuilt 1978 · S/N 441-78 N5025CSamalon William S Trustee · Juneau, AKBuilt 1978 · S/N 1053-78 N5025DCal-Aerofab Flight Academy Inc · Chino, CABuilt 1978 · S/N 366-78 N5025EStokes Field LLC · Mount Vernon, MOBuilt 1978 · S/N 438-78 N5025FAllen Scott L · Ogallala, NEBuilt 1978 · S/N 1054-78 N5025MRezich Nicholas R · Green Bay, WIBuilt 1978 · S/N 1274-78 N5025PFoley Jeffrey W · Scappoose, ORBuilt 1978 · S/N 440-78 N5025QAppel Joshua D · Redfield, SDS/N 1056-78 N5025SAir Cover Academy LLC · Frankford, MOBuilt 1970 · S/N 28R-35761 N5025TRoney William A · Santa Fe, NMBuilt 1972 · S/N 28-7225321 N5025UDuke Michael R · Mc Gregor, TXBuilt 1978 · S/N 1275-78 N5025ZDean Charles William III · Boyle, MSBuilt 1961 · S/N 22-8640 N50264Hooper Kenneth R · Hermitage, TNBuilt 1979 · S/N 1328-79 N5026BLaurie Craig M · Anchorage, AKBuilt 1978 · S/N 442-78 N5026ETurner Greg W · Delta Junction, AKBuilt 1978 · S/N 1057-78 N5026FRegistration Pending · Greenville, NCRegistration pendingBuilt 1978 · S/N 1276-78 N5026GJohnson Steven L · Salol, MNBuilt 1978 · S/N 1058-78 N5026KGriswold David M · Port Townsend, WABuilt 1978 · S/N 1278-78 N5026NWright Bruce M · Rosharon, TXBuilt 1979 · S/N 570-79 N5026RSwinney Marty Sherman Trustee · Macomb, OKBuilt 1974 · S/N 17263267 N5026SSchwenker Jerry D · Maquoketa, IAFirst renewal noticeBuilt 1979 · S/N 1326-79 N5026WSpencer Don W · The Dalles, ORBuilt 1961 · S/N 28-27 N5026ZBrown Robert C III · Whiteville, NCBuilt 1961 · S/N 22-8641 N50271Sawyer Johnson Inc · Osceola, WIBuilt 1979 · S/N 572-79 N5027FAmoia Steven M · La Mesa, CABuilt 1979 · S/N 571-79

Back to AD 81-18-04 R2