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.

N130PRPuerto Rico Police Department · San Juan, PRS/N TH-2338 N130RACarter Distribution Lc · Salt Lake City, UTBuilt 1976 · S/N 340A0040 N130RCWilliams Brian G · Las Cruces, NMBuilt 1983 · S/N P21000822 N1310CGraupman Gerald · Chicago, ILBuilt 1981 · S/N TW-1 N1313WSecond Kitchen LLC · Chicago, ILBuilt 1979 · S/N E-1440 N1314CDajczak Stanislaw P · Findlay, OHBuilt 2003 · S/N 0502 N1314UKilgore Don H · Jasper, ALBuilt 1982 · S/N 21064685 N1316RAirgo Partners LLC · Lititz, PABuilt 1968 · S/N E-125 N131DDLife Investors Aviation LLC · Milwaukee, WIBuilt 1982 · S/N D-10393 N131MADesert Eagle Aviation LLC · Albuquerque, NMBuilt 2001 · S/N 30-0059 N131PBTom Tatum Pa · Danville, ARBuilt 1975 · S/N 310R0514 N131TTCharlie Kilo Enterprises Inc · Melbourne, FLBuilt 1979 · S/N U20605010 N131TWBaron N131tw LLC · Wilmette, ILBuilt 1974 · S/N TE-963 N1321GInnovative Poultry Products LLC · Olar, SCBuilt 1976 · S/N 310R0701 N1322FHoffman Michael J · Bethel, AKBuilt 1975 · S/N 18502825 N1322LPfendt Anton N · Spring, TXBuilt 2001 · S/N 0022 N1322RMccormick Philip G · Pine Grove, CABuilt 1980 · S/N 18504122 N13297Borchers Lee A Trustee · Independence, ORBuilt 1980 · S/N 18053167 N1329UA C W Inc · Gonzales, LABuilt 1982 · S/N 21064687 N132BMds Flying LLC · Deephaven, MNBuilt 1981 · S/N TE-1189 N132BGN132bg Corp Trustee · Wilmington, DEBuilt 2005 · S/N 29-0398 N132FBRock Rivers Bancorp · Rock Rapids, IABuilt 1975 · S/N E-700 N132MABarry Casey B · Wichita Falls, TXBuilt 2001 · S/N 30-0060 N132RFTom-Wolverton Matthew J · Morris Plains, NJBuilt 2002 · S/N 0298 N132RXJ + D Aviation Services LLC · Centerville, MAS/N 402C0609 N132XParker Robert · Oklahoma City, OKBuilt 2007 · S/N L2K-23211 N1331MRegistered aircraftBuilt 1985 · S/N 21064903 N1333FMadrigales Jorge · Laredo, TXBuilt 2005 · S/N 1715 N1333SMclaughlin Sam J · Lubbock, TXBuilt 1973 · S/N 73-30601 N1333TWoodford Michael F · Fabius, NYBuilt 1969 · S/N T210-59108 N1336CMakson Leasing Co Inc · Salisbury, NCBuilt 2003 · S/N 0483 N1338GWings Air Charter LLC · Wisconsin Rapids, WIBuilt 1974 · S/N 310R0022 N1338UJstream Lc · Sheridan, WYBuilt 1965 · S/N 411-0105 N1339GLyon Aviation Inc · Pittsfield, MABuilt 1974 · S/N 310R0023 N133AGRaritan Valley Flying School · Princeton, NJS/N CE-1470 N133AWFlight Time 2 LLC · Shallotte, NCBuilt 2013 · S/N L2K-195 N133BSMusser Merton · Billings, MTBuilt 1988 · S/N CE-1234 N133CGRoq Farm LLC · Diboll, TXBuilt 1989 · S/N CE1416 N133CWDeniro Corp · Hampton, NHBuilt 1978 · S/N 310R1260 N133ECMf33a Enterprises LLC · Amarillo, TXBuilt 1992 · S/N CE-1679 N133EMWheels Up LLC · Lincoln, NES/N E-517 N133GMBem Holdings LLC · Nashville, TNBuilt 1987 · S/N CE-1170 N133MDWells Rich · Aspen, COBuilt 1987 · S/N CE-1163 N133MWSky Mile Limit · Murrayville, GABuilt 1967 · S/N CE-188 N133PCGilco Distributors · Santa Rosa, CABuilt 1976 · S/N 340A0093 N133SBColeman Terry Michael · Meridianville, ALS/N CE-891 N133TDLanyi Clifford · Attleboro, MABuilt 1990 · S/N CE-1548 N133VMCathey Gary C · El Dorado Hills, CAS/N CE786 N1342GSpector Steven D · Glenview, ILBuilt 1974 · S/N 310R0026 N1346GClear Blue Aviation LLC · Melbourne, FLBuilt 1974 · S/N 310R0029

Back to AD 86-13-04 R3