Registered aircraft · 18,497

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.

N2315FRed Rock Aircraft Leasing LLC · Hurricane, UTBuilt 1964 · S/N 21058515 N2316FTip Of The Tusk Aviation LLC · Siloam Springs, ARBuilt 1965 · S/N 210-58516 N2317SSokoloff James T · Cambridge, MAS/N E-3117 N2317VMay-Collier Aviation LLC · Atlanta, GABuilt 1998 · S/N E-3164 N2318ATarpley Gary H · Seaford, VABuilt 1997 · S/N E-3118 N2318FBe Dozer LLC · Guy, ARS/N 21058518 N2319FDelaney Patrick J · Marion, TXBuilt 1964 · S/N 21058519 N2319SHotel Whiskey Aviation LLC · San Antonio, TXBuilt 1976 · S/N 21061245 N231CZPerino Louis J · Monticello, FLBuilt 1979 · S/N 25-0175 N231JPQuest Air Inc · Cocoa, FLBuilt 1975 · S/N 414-0628 N231KYMorris Kevin William · Camden, SCBuilt 1980 · S/N 25-0293 N231LCFirst United Inc · Seminole, FLBuilt 1975 · S/N TH-696 N231LLTen-Xray LLC · Woodside, NYBuilt 2002 · S/N 0199 N231MCBrad Barnett Insurance Agency Inc · Springdale, ARBuilt 2008 · S/N E-3858 N231NPStiritz Thomas A · Spokane Valley, WAS/N 25-0111 N231PTLobbytools Aviation LLC · Friday Harbor, WABuilt 1980 · S/N P21000551 N231RLumair LLC · Northville, MIFirst renewal noticeBuilt 1980 · S/N CE-917 N231SVinegaroon Aviation LLC · Franklin, TNBuilt 1966 · S/N D-8058 N231WEJones Jason Bart · Frankfort, ILBuilt 1980 · S/N TJ-263 N231WMA Davtian M D Medical Services Inc DBA · Glendale, CAS/N 0900 N2321FMilson Charles · Sanford, NCBuilt 1964 · S/N 21058521 N2323AOutdoorsmans Dream LLC · Kalispell, MTBuilt 1969 · S/N D-9032 N2323ECherokee Beech Boys LLC · Kennesaw, GABuilt 1998 · S/N E3187 N2323FMattern Rodney · Napoleon, NDS/N 21058523 N2324AFst Aviation & Logistics LLC · Sheridan, WYBuilt 1997 · S/N E-3124 N2324FLong Rendell L · Woodbridge, VABuilt 1964 · S/N 21058524 N23251Smith Lyndsey P Trustee · Anchorage, AKBuilt 1976 · S/N 18503078 N2325FStephen N Ruark Farm Services Inc · Pantego, NCBuilt 1964 · S/N 21058525 N2326AValcourt Robert F · Chicopee, MABuilt 1998 · S/N E-3165 N2326BRandigo LLC · Wilmington, DEBuilt 1978 · S/N U20604470 N2327AN2327a LLC · Murrells Inlet, SCBuilt 1997 · S/N E-3127 N2327FWilliams Stephen Mark · Fort Walton Beach, FLBuilt 1964 · S/N 21058527 N232ASGuggenair LLC · Carbondale, COBuilt 1978 · S/N 310R1369 N232CDNew Paul · Jackson, TNBuilt 2002 · S/N 0187 N232DTChancellor Shares LLC · Liberal, KSBuilt 1979 · S/N 414A0232 N232FJConstruct Air LLC · Osage Beach, MOBuilt 2002 · S/N 0338 N232JBLundell Plastics Corp · Odebolt, IABuilt 1973 · S/N CE-448 N232MTAir Force Life Cycle Management Center · Lexington, MABuilt 1981 · S/N U20606200 N232NTorbett Michael G · Lakeway, TXBuilt 1981 · S/N CE971 N232SUWard Simon James · Sylva, NCBuilt 1967 · S/N CE-172 N232WVLewis And Clark Adventures LLC · Lewes, DEBuilt 1994 · S/N E-2906 N2330JWilliamsburg Air Service Inc · Kingstree, SCBuilt 1979 · S/N T18803455T N2331FReeves Thomas W · Issaquah, WABuilt 1964 · S/N 21058531 N2332JDon M Barron Contractor Inc · Farmerville, LABuilt 1999 · S/N E-3262 N2333BN2333b LLC · Oklahoma City, OKBuilt 1997 · S/N TH-1833 N2333VTytan Holdings LLC · Kalispell, MTBuilt 1998 · S/N E-3183 N2334WBlazek James T · Malta, ILBuilt 1997 · S/N E-3134 N2335FGravitte Peter F · Napa, CAS/N 21058535 N2335KBflyin LLC · Scottsdale, AZBuilt 1997 · S/N E-3135 N2335RPropellerhead Aviation LLC · Santa Cruz, CABuilt 1997 · S/N TH-1835

Back to AD 86-13-04 R3