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.

N2MBAlfa Foxtrot LLC · Statesville, NCBuilt 1978 · S/N 310R1357 N2MLMclaury Kim · Mission Hill, SDBuilt 1997 · S/N E-3114 N2REEtzler Richard D · Durango, COBuilt 1997 · S/N 185 N2RXJbs Enterprises LLC · Hamilton, MTS/N P21000030 N2SAInternational Air Services Inc Trustee · Carson City, NVBuilt 2005 · S/N 29-0376 N2SLLowe Aviation LLC · Bountiful, UTBuilt 1977 · S/N 21061908 N2UGBaker Gregory L · Hilton Head Island, SCBuilt 1988 · S/N CE-1267 N2VRRead Andrew R · Milwaukee, WIBuilt 1980 · S/N EA-62 N2VVAir Mods And Repair Inc · Robbinsville, NJBuilt 1976 · S/N TK-37 N2WSeldom Seen Aviation Northwest Inc · Stevensville, MTS/N 185-02982 N2WDBrantley Scott R · Great Bend, KSBuilt 1950 · S/N NAV-4-2153-B N2XFN2xf LLC · Windermere, FLBuilt 2008 · S/N 3RX029 N2XSCarter Delton W · Montgomery, TXBuilt 1988 · S/N 88-301000 N2YEAllied Moulded Products Inc · Bryan, OHBuilt 1975 · S/N 310R0577 N2YROverland Missions Inc · Cocoa, FLS/N U20601737 N2ZTwo Zulu LLC · Mclean, VABuilt 1989 · S/N E-2514 N2ZHClt Thompson Holdings LLC · Charlotte, NCBuilt 2001 · S/N 0056 N2ZWThordarson Gudsteinn Thor · La Porte, INBuilt 1956 · S/N D-4564 N3000DHungy Air LLC · Bettendorf, IABuilt 2001 · S/N 0083 N3002WRio Concho Aviation Inc · Weatherford, TXBuilt 1973 · S/N E-453 N30038Stockyard LLC · Wilmington, DEBuilt 1973 · S/N 21059879 N3007WLima Mike Inc · Ham Lake, MNBuilt 1973 · S/N TH-365 N300ABDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1966 · S/N D-8056 N300BDAircraft Inc · White Bear Lake, MNBuilt 1975 · S/N 310R0258 N300CGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 414A0121 N300CLHustak Michael G · Granbury, TXBuilt 1969 · S/N D-8913 N300EB4031 Pilots LLC · Crown Point, INBuilt 1974 · S/N 310R0082 N300EW2f Trade LLC · Collinsville, TXS/N 21061219 N300GMidwest Partitions Flight Services LLC · Thedford, NEBuilt 2013 · S/N E-3992 N300HCPs Air LLC · Evansville, INBuilt 1983 · S/N 21064804 N300HMEngage Communication Inc · Aptos, CABuilt 2001 · S/N 40011 N300KKrakeel James A · Mount Pleasant, SCBuilt 1977 · S/N TE-1103 N300MBIglesia De Cristo · Porter Ranch, CABuilt 1974 · S/N 421B0573 N300MSChua Johann L · Daly City, CABuilt 1969 · S/N TE-688 N300NVHolombo Lee C · Trenton, KYBuilt 2003 · S/N 40064 N300PJLegacy Of Speed LLC · Warsaw, INBuilt 1975 · S/N HC2A N300PM300pm LLC · Bloomington, INBuilt 1978 · S/N 310R1382 N300RRRegan Richard Michael · Leesburg, VAS/N CE-177 N300RTChoux Aviation LLC · Cypress, CABuilt 1983 · S/N E-2074 N300SAWhalen Sean B · Naples, FLS/N CE-545 N300SQVortex Aviation LLC · Houston, TXBuilt 1979 · S/N 414A0416 N300THPacific Flight Academy LLC · Honolulu, HIBuilt 1972 · S/N TH-266 N300TLAlls Peyton H · Raleigh, NCBuilt 2003 · S/N 40067 N300TTDg Aero LLC · Little Rock, ARBuilt 1980 · S/N CE-906 N300YBGospel Ministries International Inc · Collegedale, TNBuilt 1986 · S/N 24-3010 N3012HBonanza Two USA Inc Trustee · Wilmington, DEBuilt 1987 · S/N CE-1109 N3014WRunyan Joseph D · Bushnell, ILBuilt 1973 · S/N TE-933 N3017WKirk Michael E · Alvin, TXBuilt 1973 · S/N D9520 N301BZPin High LLC · Ruston, LABuilt 2005 · S/N E-3642 N301CPWhy Not Fly Aviation LLC · Gainesville, VAS/N 414A0105

Back to AD 86-13-04 R3