Registered aircraft · 18,495

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N78BBRadwanski D · Westmont, ILBuilt 1977 · S/N 310R1246 N78BCMastin William · Fort Worth, TXBuilt 1989 · S/N EA-499 N78BEHappy Planes LLC · Boyertown, PABuilt 1978 · S/N E-1178 N78BFSandbar Air LLC · Saint Petersburg, FLBuilt 1972 · S/N E-331 N78BLLaukka Bruce L · West Rockport, MEBuilt 1977 · S/N 18503324 N78CDPolyresources · Naperville, ILBuilt 2003 · S/N 0456 N78DBGreenbrier Aviation LLC · Sevierville, TNBuilt 1980 · S/N TH-1152 N78DGUsac N78dg LLC · Wall Township, NJBuilt 1981 · S/N 414A-0641 N78DUDel Azar Helen Rogers · SurreyNon-citizen corporation, flight hours not reportedBuilt 2009 · S/N E-3897 N78EEEagle Property Group LLC · Virginia Beach, VABuilt 2002 · S/N 0325 N78FWoods Joseph Lee · Gilbert, AZBuilt 1963 · S/N 21058258 N78GGSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N CE-699 N78GWCbs Aviation LLC · Jackson, MSBuilt 1978 · S/N E-1351 N78HFFiorentini Henry · Lincolnshire, ILBuilt 1979 · S/N CE-887 N78KC5634 Aviation LLC · Flowery Branch, GABuilt 1978 · S/N 414A-0045 N78KGClayton Donald D · Sugar Land, TXBuilt 1975 · S/N E-643 N78KJMuzquiz Alberto · San Antonio, TXBuilt 1976 · S/N 310R0669 N78KKJim Heck Investments LLC · Findlay, OHBuilt 1977 · S/N D-10075 N78KLNea Industrial LLC · Paragould, ARBuilt 1990 · S/N TH-1578 N78KWVolz James R · Laredo, TXBuilt 1974 · S/N U20602647 N78MKNelleh LLC · Liberal, KSBuilt 1978 · S/N 21062587 N78MWSymple Consulting LLC · Topeka, KSBuilt 1976 · S/N U20603205 N78NGRam Aero Development Inc · Waco, TXS/N 414A0617 N78REKhg Aircraft Inc · Peachtree City, GAS/N TH-371 N78RSSkorpiks Inc · Tyndall, SDBuilt 1980 · S/N D-10360 N78SBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 340-0151 N78TFPritchett Thomas E · Post Falls, IDBuilt 1999 · S/N 30-0037 N78UMDenver Air Support Inc · Englewood, COS/N TJ-84 N78VFandler Fred E · Denton, TXBuilt 1996 · S/N 29 N78VCBb58 LLC · Greenville, MSBuilt 1995 · S/N TH-1743 N78WHDel Rosi Anthony J · Key Largo, FLBuilt 1978 · S/N D-10145 N78WVOrange Motion Trading LLC · Las Vegas, NVBuilt 1977 · S/N 21062214 N78WWPark Avenue Group Inc · Stuart, FLBuilt 1995 · S/N TH-1747 N79007Hardy Robert C · Plantation, FLBuilt 1997 · S/N ES-022 N7900KThykeson Air LLC · Portland, NDBuilt 1964 · S/N D-7403 N7900MRegistered aircraftBuilt 1966 · S/N D-8223 N7900SPanther City Air LLC · Fort Worth, TXBuilt 1965 · S/N D-7900 N7901KBarber Victor L · Blanket, TXBuilt 1964 · S/N D-7404 N7901QKentucky Airmotive Inc · Mount Sterling, KYBuilt 1969 · S/N 401B0001 N7902MBig Blue Sky LLC · Indianapolis, INBuilt 1966 · S/N D-8227 N7903KRegistered aircraftBuilt 1964 · S/N D-7710 N7903MNichols Andrew · Harrells, NCBuilt 1966 · S/N CE-72 N7905MSpradin Gilfred Lyle Jr · Northumberland, PABuilt 1967 · S/N TE-332 N7905RFlaherty Ryan J · Scottsdale, AZBuilt 1970 · S/N E-230 N7907MShipman Johnny R · Sealy, TXBuilt 1966 · S/N CE-81 N79080Snider Roger A · Harlem, MTBuilt 1974 · S/N 18801962 N7908KManning Howard L · South Lake Tahoe, CABuilt 1964 · S/N D-7407 N7908RDoonair LLC · Loomis, CABuilt 1969 · S/N CE-267 N7909QSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N 310Q0620 N790JWWorkman Properties LLC · Muskegon, MIBuilt 1955 · S/N G-790

Back to AD 86-13-04 R3