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.

N5125BSnohomish Flying Service Inc · Snohomish, WABuilt 1979 · S/N 15283762 N5125DValdes Eusebio · Miami, FLBuilt 1974 · S/N 17264231 N5125GRogers William A II · Indn Hbr Bch, FLBuilt 1968 · S/N 17257022 N5125MSampson Alan T · Indianapolis, INBuilt 1978 · S/N M-2030 N5125PWalton Josh A · Westcliff, COBuilt 1958 · S/N 24-138 N5125SSlade Clark K · Pinckney, MIBuilt 1971 · S/N 28R-7135157 N5125TAdflight Inc · Lafayette, LABuilt 1981 · S/N R18201818 N5125VKalchev Dimitar · Fishers, INBuilt 1961 · S/N SP-21 N5125WElyon Holdings LLC · Gulf Shores, ALBuilt 1961 · S/N 28-151 N5125XBaker Daniel E · Saint Petersburg, FLS/N 114 N5125YTassopoulos Thomas · Flushing, NYBuilt 1962 · S/N 27-2158 N5126EHouk Sean R · Lyons, OHBuilt 1978 · S/N 17271724 N5126GMag-Aero Inc · Harvard, ILBuilt 1979 · S/N 17273551 N5126HBradbury Douglas · Pedro Bay, AKBuilt 1948 · S/N 14-135 N5126JGull Rock Aviation LLC · Punta Gorda, FLBuilt 2001 · S/N 172S8992 N5126LMccoy Jiro · Fort Walton Beach, FLBuilt 1967 · S/N 28-4409 N5126PElie Jonathan · Hopewell Junction, NYBuilt 1958 · S/N 24-139 N5126QAvco Patrol LLC · Lyndon, KSBuilt 1973 · S/N 17261757 N5126RAirborne Investors Corp · Buford, GABuilt 1974 · S/N 17263343 N5126SRyan Kevin M · Xenia, OHBuilt 1971 · S/N 28-7105173 N5126TBelle Fourche Flight Center LLC · Belle Fourche, SDS/N 547 N5126VSkylark Flight Training LLC · Wilmington, DEBuilt 1980 · S/N 172RG0452 N5126WCook Jackson W · Buckley, WAS/N 28-152 N5126ZAshley Emory R · Panacea, FLBuilt 1961 · S/N 22-8767 N51274Worley Farms · Atwood, KSBuilt 2008 · S/N 91089 N5127GKurtz Joseph A · Hamilton, GAS/N 28-24675 N5127HSmith Dan R · Montrose, SDBuilt 1975 · S/N 17265344 N5127RAmerican Industrial Laundry · Lander, WYBuilt 1974 · S/N 17263344 N5127SWeston Thomas J · Stratford, NJBuilt 1971 · S/N 28-7125457 N5127VGriffy Paige E · Decatur, ILS/N SP-23 N5127YAirborne Extreme LLC · Wasilla, AKBuilt 1962 · S/N 18-7895 N5127ZPohland Charles A · Anchorage, AKBuilt 1961 · S/N 18-7765 N51282Registration Pending · West Point, NERegistration pendingBuilt 2002 · S/N T20608359 N5128BEastman Gregory L · Pueblo, COBuilt 1980 · S/N 172RG0279 N5128DKingsky Flight Academy LLC · Lakeland, FLBuilt 1979 · S/N 17272430 N5128GSale Reported · Gainesville, FLSale reported, pending cancellationBuilt 1968 · S/N 28-24669 N5128LSquawk 2017 LLC · Flowery Branch, GABuilt 1967 · S/N 28-4411 N5128PSchafer David · Northport, ALBuilt 1958 · S/N 24-141 N5128RBend Aircraft Mechanics LLC · Bend, ORBuilt 1974 · S/N 17263345 N5128SDonegan Martin A O · Bethlehem, PABuilt 1971 · S/N 28-7125512 N5128VBeulen Brian V · Mesa, AZBuilt 1961 · S/N SP-24 N5128ZMoore Merritt T II · Silver Creek, NYBuilt 1961 · S/N 22-8769 N51295Right Brother Aviation LLC · Chaffee, NYBuilt 1980 · S/N 17274295 N51297Ingram Dale D · Klamath Falls, ORS/N 17264232 N5129QWaters John E · Renton, WABuilt 1973 · S/N 17261758 N5129SSplendid Aviation Inc · Corpus Christi, TXBuilt 1971 · S/N 28-7125600 N5129VBirdzell Luther E · Hood River, ORBuilt 1961 · S/N SP25 N5129WStanek Kenneth W Jr · Russellville, ARBuilt 1961 · S/N 28-156 N5129XSmall Aviation No 2 LLC · Villa Rica, GABuilt 1969 · S/N 171 N5129YCarter Ronald Lynn · Nenana, AKS/N 12-1554

Back to AD 81-18-04 R2