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.

N4679HAdams Kris · Griffin, GABuilt 1979 · S/N 24-0808 N4679WBravo Whiskey LLC · Cascade, COBuilt 1978 · S/N 13255 N467AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843741 N467AAWings Over Texas Holdings LLC · Denton, TXBuilt 2025 · S/N 353/US N467AT467at LLC · Frankfort, ILBuilt 1968 · S/N 17700879 N467CMIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 17280859 N467DKRegistered aircraftBuilt 1995 · S/N 467 N467ERWingsleasing LLC · Wichita, KSS/N 172S10287 N467FAMain Line Flight School LLC · Haverford, PABuilt 2022 · S/N 28020067 N467GRRoach Gene T · Frankfort, KYS/N 892 N467HABuell Travis · Harper, TXBuilt 2001 · S/N 0984 N467PEOkane James K · Noblesville, INBuilt 2013 · S/N 1 N467QStegner John J · Boonville, MOBuilt 1976 · S/N 17266649 N467TFHarts Joel D · Coffeyville, KSBuilt 1995 · S/N 1 N467TSPsl Surveys · Manassas, VABuilt 2010 · S/N 18282239 N468Downs Daniel D · Phoenix, AZBuilt 1982 · S/N 7417C N46803Ken Graham Phd Inc · Sioux Falls, SDBuilt 1979 · S/N 15283108 N4680JCorral Oscar L · Ft Stockton, TXS/N 350 N4680RGibbs Robert I · Ravenswood, WVBuilt 1966 · S/N 28-21439 N4680ZPropelling The Gospel Missions Inc · Standish, MEBuilt 1961 · S/N 22-8215 N4681JRose Jeffrey R · Niceville, FLS/N 28R-30581 N4681SRezek William E · Centennial, COBuilt 1979 · S/N R18201377 N46826Registration Pending · Tampa, FLRegistration pendingBuilt 1979 · S/N 15283114 N46828Petro Jerry R · Williamsburg, VABuilt 1953 · S/N 2009 N4682DBusch Craig D · Green Brook, NJBuilt 1979 · S/N 17272330 N4682JAhz Aviation LLC · Shawnee, KSBuilt 1968 · S/N 28R-30561 N4682RTremblay Stanley R Sr · Dexter, MEBuilt 1966 · S/N 28-21441 N4683STorley Christopher · Flower Mound, TXBuilt 1979 · S/N R18201378 N4683TBatchelor William · Sicklerville, NJBuilt 1972 · S/N 28-7225199 N46846Boudreau Robert D · Rusk, TXBuilt 1978 · S/N AB005 N4684CSmith Cameron T · Placitas, NMBuilt 2008 · S/N 68 N4684JByrne Matthew A · West Allis, WIBuilt 1968 · S/N 28R-30585 N4684SVeracity Aviation LLC · Seguin, TXBuilt 1999 · S/N 2996 N4684TMk Aviation LLC · Charlotte, NCS/N R18201733 N4684ZGordon Stephen M · Velpen, INBuilt 1961 · S/N 22-8219 N46854Phillips Joe Christopher · Grand Prairie, TXBuilt 1979 · S/N 15283121 N4685JGaither William W · Shallotte, NCBuilt 1968 · S/N 28R-30586 N4685SSeneca Aeronautical Services LLC · Wilmington, DEBuilt 1965 · S/N EC-1 N4685TMalagrifa Richard · Swampscott, MABuilt 1981 · S/N R18201734 N4686ESieh Colton David · Kotzebue, AKS/N 7EC-34 N4686LGlenn Roger H · Pacifica, CABuilt 1980 · S/N 15284216 N4686VRegistration Pending · Patterson, LARegistration pendingS/N 172RG0365 N4686ZMacmoyle Scott · Blairstown, NJBuilt 1961 · S/N 22-8222 N4687JPletcher Enterprises Inc · Muscatine, IABuilt 1968 · S/N 28R-30589 N4687MHock Rocky · Culbertson, NEBuilt 1947 · S/N 11-196 N4687RMontz Steven Andrew · Mandeville, LABuilt 1966 · S/N 28-21448 N4687SP & V Howard Enterprises LLC · Angleton, TXBuilt 1979 · S/N R18201380 N4687VSharp Cutlass LLC · Iowa City, IABuilt 1980 · S/N 172RG0366 N4687WAmerican Dream Aviation LLC · Woodhaven, NYBuilt 1978 · S/N 13263 N46889Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283133

Back to AD 81-18-04 R2