Skip to content

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.

N881JTInternational Jet Traders Inc · Fort Lauderdale, FLBuilt 2007 · S/N TH-2194 N881JVVoss James S · Boulder, COBuilt 2004 · S/N 1032 N881PJJohnson Patrick Allen · Olive Branch, MSBuilt 1973 · S/N 310Q0754 N881PRMcdonald William H · Anchorage, AKS/N 18504209 N881SRegistration Pending · Sulphur Rock, ARRegistration pendingBuilt 1973 · S/N CE-454 N881TCBrait Aviation LLC · Edina, MNBuilt 2005 · S/N 1649 N881TJBarron Eddie T · Amarillo, TXBuilt 1972 · S/N 414-0259 N881WD306kc LLC · Hockley, TXBuilt 2004 · S/N 1215 N8822JSwyryn Alexander Douglas · Cape Coral, FLBuilt 1973 · S/N 73-30606 N8823HBowers Phillip P · Clayton, NCBuilt 1970 · S/N 21059314 N8824MHalpern Joseph Robert · Apo, AEBuilt 1964 · S/N D-7344 N8825GRichardson Dean A · St Thomas, VIFirst renewal noticeBuilt 1981 · S/N 404-0628 N8825VPosey Robert L · Newport Beach, CAS/N 30366 N8826MAeolus LLC · Portland, MEBuilt 1964 · S/N D-7373 N8826VBush Edward L · Bainbridge, GABuilt 1971 · S/N 30347 N8827MNewport Elite LLC · Newport Beach, CABuilt 1964 · S/N D-7347 N882BCTechnology Aviation Services LLC · Covington, GABuilt 1973 · S/N 414-0470 N882CCSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1989 · S/N CE1345 N882CDRegistered aircraftBuilt 2002 · S/N 0295 N882CTCharlie Tango Aviation LLC · Rocklin, CABuilt 1990 · S/N E-2566 N882MTGta Air Inc · Addison, TXBuilt 1982 · S/N TH1343 N882TGoing Bonanzas LLC · Scottsdale, AZBuilt 1965 · S/N D-7784 N882WBWright Bros Flying Club LLC · Lewes, DEBuilt 2002 · S/N 0360 N8830MRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1964 · S/N D-7348 N8833AChrzanowski Sigmund J Trustee · Hampshire, ILBuilt 1982 · S/N CE-976 N8834MPilots Discretion LLC · Atlanta, GABuilt 1964 · S/N D-7352 N8835MKnight Robert T · Baton Rouge, LABuilt 1964 · S/N D-7353 N8837MNewpower Scott · Seeley Lake, MTBuilt 1964 · S/N D-7346 N883JPGemis Paul · Nantucket, MABuilt 2002 · S/N 0363 N883TEasley Toby · Lucama, NCBuilt 1965 · S/N D-7770 N8840VN8840v LLC · Longmont, COBuilt 1971 · S/N 30377 N8841MBanana Boys LLC · Seattle, WABuilt 1964 · S/N D-7365 N8843UGullatt Jamey D · Mount Airy, NCBuilt 1965 · S/N 17252754 N8843VHamstra Siebe · Chandler, AZBuilt 1971 · S/N 30367 N8844GNorthside Logistics And Automotive Inc · Dardanelle, ARS/N 21059144 N8844MNewberry Travis · Niota, TNBuilt 1964 · S/N D-7357 N8845QJohnson James W · Wilmot, ARBuilt 1979 · S/N 18503776 N8847VZollars Thomas B · Dallas, TXBuilt 1971 · S/N 30359 N8848MFly Shetland LLC · Lubbock, TXS/N D-7360 N884CN884c LLC · Georgetown, SCBuilt 2003 · S/N 0446 N884CDBcd Aviation LLC · Waleska, GABuilt 2005 · S/N 1567 N884KSWhitehurst Kenneth J · Shreveport, LABuilt 2011 · S/N E-3950 N884TPerryton Motor Co Inc · Perryton, TXBuilt 1965 · S/N D-7807 N8851KJac Leasing LLC · Fort Myers, FLBuilt 1979 · S/N 414A0239 N8851MBal-Kar Holdings Inc · Punta Gorda, FLBuilt 1964 · S/N D-7362 N88521Godfrey Pharis · Missouri City, TXBuilt 1981 · S/N 340A1260 N8852MAndys Auto Sales LLC · Caroline, WIBuilt 1964 · S/N D-7367 N8853K8853k LLC · New Bedford, MABuilt 1979 · S/N 414A0240 N8853MBeaver Creek Aviation LLC · Clinton, OKBuilt 1964 · S/N D-7368 N88549Seed Richard J IV · Holmes Beach, FLBuilt 1981 · S/N 340A1261

Back to AD 86-13-04 R3