Skip to content

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.

N13674Bentley Robert H · Lockport, ILBuilt 1974 · S/N 17262933 N13675Valz Thomas M · Cleveland, OKBuilt 1974 · S/N 17262934 N1367ALl Wings LLC · Minnetonka, MNBuilt 1951 · S/N 18-1196 N1367CFerguson Bruce W · Fort Peck, MTBuilt 1953 · S/N 18-2626 N1367PBuzzard Air Service LLC · Carleton, MIBuilt 1956 · S/N 23-416 N1367TN1367t LLC · Mount Dora, FLBuilt 1972 · S/N 28R-7235271 N1367WSelover Richard D · Colusa, CABuilt 1963 · S/N 2648 N13680Macvicar Angus C · Nantucket, MABuilt 1974 · S/N 17262937 N13681Davis Jerry L · Rural Retreat, VABuilt 1976 · S/N 17702453 N13682Moynihan Quinn A · Apple Valley, MNBuilt 1974 · S/N 17262939 N13683American Patrols Inc · Midland, TXBuilt 1974 · S/N 17262940 N13684Matyas Martin M · Helena, OHS/N 17262941 N13685Lee Valley Inc · Tekamah, NEBuilt 1974 · S/N 17262942 N13686T Craft Aero Club Inc · Nampa, IDBuilt 1974 · S/N 17262943 N1368AMcknight Thomas N · Fredericksburg, TXBuilt 1951 · S/N 18-1197 N1368BStallings Jerry W · Ferriday, LABuilt 1983 · S/N 222 N1368PDoan William Terry · Furlong, PABuilt 2019 · S/N 1240 N1368URed Baron Flyers · Caledonia, MNBuilt 1976 · S/N 17267039 N1369Low Country Skyways LLC · Wilmington, DEBuilt 1969 · S/N RLG-316 N13690Dyre Daniel · Park Rapids, MNBuilt 1976 · S/N 17702454 N13692American Patrols Inc · Midland, TXBuilt 1974 · S/N 17262946 N13693Iowa Lakes Community College · Estherville, IABuilt 1974 · S/N 17262947 N13696Johnson Mildred J Executor · Boerne, TXBuilt 1974 · S/N 17262950 N13698Park Avenue Group Inc · Stuart, FLBuilt 1974 · S/N 17262952 N1369BFryt Michael J · Goldsboro, NCS/N 371-72 N1369JWalsh Mark · Andover, MABuilt 1975 · S/N 369 N1369QAmeriflyers Of Texas Inc · Addison, TXBuilt 2005 · S/N 172S9946 N1369RRyals Jon Harris · Billings, MTBuilt 1975 · S/N AA5-0769 N1369TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250301 N136ACPreacher John R · Jackson, GAS/N 673-92 N136AVHarford Archer Owners Group LLC · Bel Air, MDBuilt 1984 · S/N 28-8590004 N136BCBounds Robert E · Seward, NES/N 01 N136BDBrodersen Steve A · Lexington, KYBuilt 2007 · S/N 80264 N136CCShelk John Brian · Bend, ORBuilt 2002 · S/N 9953CC N136CHHall Kenneth C · Kernersville, NCBuilt 2004 · S/N 449 N136CPMaule Flight Inc · Moultrie, GABuilt 2002 · S/N 18071C N136DBuckeye Ridge Farm LLC · Vidalia, GABuilt 1978 · S/N 14361 N136DCStreamline Aviation LLC · Battlefield, MOBuilt 1982 · S/N 136 N136DKReece Robert B · Halstead, KSBuilt 2003 · S/N 24654 N136DWSun Aircraft Management LLC · Ormond Beach, FLBuilt 2003 · S/N 4496168 N136EJForeman Guy W · Valparaiso, INBuilt 1979 · S/N 38-79A0572 N136FSale Reported · Broomfield, COSale reportedBuilt 2001 · S/N 60300 N136FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290171 N136HKuether Daniel D · Norfolk, NEBuilt 1999 · S/N 1091-1 N136HAEnstrom Helicopter Corp · Menominee, MIBuilt 2015 · S/N 2143 N136HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9711 N136HSHenderson State University · Arkadelphia, ARBuilt 2007 · S/N 21094C N136JMGregory Warren D Jr · Aguila, AZBuilt 1963 · S/N 22-5557 N136LMLge Flying Club · Canton, GABuilt 1975 · S/N 17265041 N136MMMiller Carl A · Vero Beach, FLBuilt 1993 · S/N 21718

Back to AD 81-18-04 R2