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.

N898ZKCarltrustee Consulting Inc · Coto De Caza, CAS/N 1312 N8990MHayden Patrick Jr · Lexington, KYBuilt 1964 · S/N D-7312 N8991GAll Trimmed Out LLC · Pierre, SDBuilt 1977 · S/N 340A0329 N8993MNorthwood Holdings LLC · Dugspur, VABuilt 1964 · S/N D-7316 N8995MCollins Sherman C · Sedona, AZBuilt 1964 · S/N D-7317 N8997Pxv Holdings LLC · Evansville, INBuilt 2015 · S/N TH-2447 N8999GSouther Field Aviation Inc · Americus, GAFirst renewal noticeBuilt 1973 · S/N 18801344 N899CDBowles Services LLC · Houston, TXBuilt 2002 · S/N 0297 N899MDLarson Aeromedical Services LLC · Salem, ORS/N 21059984 N899RBRoach John H · North Salem, NYBuilt 1976 · S/N CE634 N899RCOsprey Aviation LLC · Hamilton, MTBuilt 1978 · S/N U20604808 N899TEtherington Charles A Trustee · Vlg Loch Loyd, MOBuilt 1971 · S/N D-9297 N899TTTangtang Gang LLC · Lewes, DEBuilt 2002 · S/N 0203 N89ADClairmont Holdings Vi LLC · St Thomas, VIS/N 402C0115 N89AUAllen Esta Ross III · Houston, TXBuilt 1987 · S/N CE-1129 N89EDPage Daniel R · Raleigh, NCBuilt 1979 · S/N E-1479 N89ELHorner James G · Santa Clara, CABuilt 1989 · S/N 89-301009 N89EPBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 21060380 N89GPanousis Steve · Kennett, MOBuilt 1975 · S/N TH-616 N89GHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 1178 N89GTMinasian Paul Ryan Trustee · Oroville, CABuilt 1989 · S/N CE-1383 N89HWHw Air Lc · Salt Lake City, UTBuilt 2001 · S/N 40016 N89JSPh Flight Services LLC · Wilmington, DEBuilt 1967 · S/N D-8537 N89KBJet Sense Aviation Aircraft Holdings Corp · Burlington, WIS/N EA-54 N89KPRegistered aircraftBuilt 1979 · S/N 21063501 N89LRA36 Gps LLC · Boone, NCBuilt 1982 · S/N E-2058 N89LSCals Ltd · Harbor Springs, MIBuilt 1991 · S/N CE-1583 N89NXCardinal Account Services Inc DBA · Mentor, OHBuilt 2004 · S/N 1004 N89PDCaleta Ventures LLC · Richmond, TXBuilt 1979 · S/N E-1554 N89PFBrown Jeffrey T · Sherman, ILBuilt 2003 · S/N 40074 N89SGHatch Christopher L · Harpswell, MEBuilt 1989 · S/N CE-1357 N89UMIsbell Services LLC · Tuscaloosa, ALBuilt 2004 · S/N 0971 N89ZMDx Aviation LLC · Broken Arrow, OKBuilt 1989 · S/N CE-1413 N8APacific Aviation LLC · Cottage Grove, ORBuilt 1976 · S/N 18502852 N8ADChelsea Build LLC · Brenham, TXS/N EA-359 N8AJBs Designs Inc · Decatur, TXFirst renewal noticeBuilt 1966 · S/N P206-0335 N8AVOtis Air Service Inc · Wichita, KSBuilt 1974 · S/N 421B0663 N8BLPro One Janitorial Inc · Chicken, AKBuilt 1970 · S/N 414-0098 N8BNHopkins Darren M · Aiken, SCS/N CE-38 N8CCMag 3 Aviation LLC · Vidor, TXBuilt 1981 · S/N 21064437 N8DPDelta Papa Aviation LLC · Wilmington, DES/N TH-1038 N8EYMoore Robert Russel Sr · Austin, TXBuilt 1985 · S/N P21000850 N8FBRichland Aviation Inc · Sidney, MTBuilt 1978 · S/N 402B1372 N8FJCheap Thrills I LLC · Salida, COBuilt 1969 · S/N E-187 N8FMSky Dawg LLC · Winterville, NCBuilt 1997 · S/N E-3068 N8KJBenjabr Inc · Fresno, CANon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 310R1392 N8KMWolding Jeffrey D · Ashland, WIBuilt 1974 · S/N 21060260 N8KWSigurdson Richard J · Olivia, MNBuilt 1977 · S/N D-10091 N8KXTroutman Shaun L · Johnson, KSBuilt 1992 · S/N 37 N8MPForeman Thomas H · Orange, TXBuilt 1966 · S/N D-8059

Back to AD 86-13-04 R3