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.

N3612WKard Aviation LLC · Greenville, SCBuilt 1966 · S/N 32-513 N36134Manning John W · Floyds Knobs, INBuilt 1978 · S/N 28-7816615 N36137Big Bend Community College · Moses Lake, WABuilt 1973 · S/N 542-73 N36138Smith Brian Lee · Solvang, CABuilt 1973 · S/N 382-73 N36139Flying Sportsmen Inc · Sussex, NJBuilt 1973 · S/N 105-73 N3613AWarren Charles J · Sarver, PABuilt 1953 · S/N 22-1873 N3613MHall Gary L · Delta Junction, AKBuilt 1947 · S/N 12-2459 N3613NBradbury Kevin Earl · Saint George, UTBuilt 1967 · S/N 680011 N3613PLittle Bear Air LLC · Lubbock, TXS/N 22-3339 N3613WTurner Travis · Chetek, WIS/N 32-514 N36140Phillips James M · Wilmington, NCBuilt 1973 · S/N 957-73 N36141Averill Terry B · Litchfield, MEBuilt 1973 · S/N 544-73 N36149Gilbert Paul · Diamondhead, MSBuilt 1978 · S/N 32R-7885165 N3614QMay Robert L · Spring Branch, TXBuilt 1967 · S/N MB-252 N3614RKrautschun Bart · Spearfish, SDS/N 28-5710 N3614XPanther Enterprises LLC · Fort Myers, FLS/N 5090 N36150Bas Part Sales LLC · Greeley, COBuilt 1978 · S/N 32R-7885166 N3615MRenfro Michael W · Bethel, AKBuilt 1947 · S/N 12-2461 N3615NWalker Eric L · Southlake, TXBuilt 1967 · S/N 680012 N3615QPlane Safe Aircraft Maintenance Inc · Waukesha, WIS/N MB-237 N36167James Brett · Louisburg, NCBuilt 1978 · S/N 28-7890497 N3616ARegistration Pending · Safford, AZRegistration pendingS/N 22-1876 N3616MPrince Benjamin D · Lincoln, MTBuilt 1947 · S/N 12-2462 N3616NDe Masters Jasper · Bakersfield, CABuilt 1967 · S/N 680013 N3616PKidd Myles · Machesney Park, ILBuilt 1955 · S/N 22-3344 N36173Schuster Darin D · New Castle, DEBuilt 1973 · S/N 546-73 N36174Meise Fred W · Moses Lake, WABuilt 1973 · S/N 958-73 N36176Otte Duane P · Plainfield, INBuilt 1973 · S/N 101-73 N36178California Flyers Training Solutions LLC · Sun City, CABuilt 1973 · S/N 383-73 N3617PPhilpott Gary D · Camden, SCBuilt 1956 · S/N 22-3723 N36185Stapleton Rita · Gallipolis, OHBuilt 1978 · S/N 32R-7885169 N36187Swaz Aviation LLC · Mesa, AZBuilt 1978 · S/N 28-7816619 N3618CHoshor Matthew David · Wetumpka, ALBuilt 1978 · S/N R18200278 N3618MRatcliffe Andrew M · Jerome, AZBuilt 1978 · S/N 28-7890319 N3618NYoung Donald Colin · West Plains, MOBuilt 1967 · S/N 680014 N3618XHildenbrand Casey E · Circleville, OHBuilt 1968 · S/N 5095 N36194Cripps Alan Stephen · Hoover, ALBuilt 1978 · S/N 32R-7885171 N3619KKirk Trevor A · Ponderay, IDBuilt 1967 · S/N 28-23656 N3619MMartinson Douglas E · Nome, AKBuilt 1947 · S/N 12-2517 N3619NChiques Aero Corporation · Lancaster, PABuilt 1967 · S/N 680015 N3619RBachelor Cabin Flying Services Inc · Kokomo, INBuilt 1969 · S/N 28-5714 N3619XNeeds Shaely M · Pueblo, COS/N 5096 N361ACBond Robert E · Kingsville, MOBuilt 1974 · S/N 497-75 N361AKAronson Kenneth I Trustee · Truckee, CABuilt 2016 · S/N 91935 N361CPBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 172S8840 N361DBLcb Leasing · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282245 N361ESGrady Paul D · Reno, NVBuilt 1997 · S/N 17280011 N361ETW Fairfield Aviation Inc · Caldwell, KSS/N 437 N361FSBlue Yonder Aviation Inc · Rochester, NYBuilt 1997 · S/N 23039C N361GAGlidewell Aviation Inc · Parkland, FLBuilt 2003 · S/N 172S9521

Back to AD 81-18-04 R2