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.

N7984M84m LLC · Bixby, OKBuilt 1966 · S/N CE-121 N7987KSharair LLC · Thomasville, GABuilt 1964 · S/N D-7491 N7987MKrikorian Philip R · Fresno, CABuilt 1966 · S/N D-8273 N7987RHopeful Monster LLC · Ann Arbor, MIBuilt 1969 · S/N D-8975 N7988KUnlimited Horsepower LLC · Lewisburg, WVBuilt 1964 · S/N D-7492 N7988MBlandon Pedro Md Pa · El Paso, TXBuilt 1967 · S/N D-8471 N7988QCerniglia Paul · Monroe Township, NJBuilt 1971 · S/N 401B0207 N7989QLauritano Stephen G · Goodyear, AZBuilt 1971 · S/N 401B0208 N7989RBack In The Saddle LLC · Nashville, TNBuilt 1969 · S/N TE-714 N798BBFlyboys LLC · Mobile, ALBuilt 2005 · S/N 1435 N798GMJust US Pilots Inc · Clearwater, FLBuilt 1998 · S/N E-3184 N798JBMidwest Aircraft LLC · Olathe, KSBuilt 2002 · S/N E-3468 N798RDSmith Lawrence M · Jacksonville, FLBuilt 1967 · S/N D-8528 N7991MTrapp Brian W · Lebanon, OHBuilt 1966 · S/N CE-93 N7993MZiebarth William R · Powell, OHBuilt 1966 · S/N CE-92 N7994KReynolds Gary L · Colorado Springs, COBuilt 1964 · S/N D-7502 N7995KHall Benjamin H Jr · Tullahoma, TNBuilt 1964 · S/N D-7501 N7995MBowers Kevin · Lawrenceville, GABuilt 1966 · S/N CE-94 N7996MHager Terry L · Texhoma, OKBuilt 1966 · S/N CE-96 N7998MBertelli Leonard DBA · Lancaster, SCBuilt 1966 · S/N D-8278 N7999KBristol Bay Capital LLC · Watkins, COS/N D-7578 N799CDGpa Inc Trustee · Wilmington, DEBuilt 2005 · S/N 1543 N799ESFive Boys Flight Training LLC · Matthews, NCBuilt 1981 · S/N 414A0657 N799KTAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1976 · S/N U20603580 N799PCRegistration Pending · Colorado Springs, CORegistration pendingBuilt 1966 · S/N T210-0178 N799TFGallien Anthony · Livermore, CAS/N 421B0324 N799XSemanskee Grant W · Snohomish, WAS/N CE-137 N79APHigh Tide Aviation LLC · Naples, FLBuilt 1979 · S/N TJ206 N79ASPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N 340A1248 N79BPOrion 207 LLC · Harpswell, MEBuilt 1979 · S/N 414A0263 N79CCN79cc LLC · Paragould, ARBuilt 1969 · S/N TE-764 N79CHPala Angel E · Taos, NMBuilt 1978 · S/N 21062615 N79CMHf Jet Service LLC · Mountain Home, ARBuilt 2023 · S/N TH-2539 N79DCBnb Marine LLC · Miami, FLS/N 414A0212 N79DRMcneill Steve · Santa Fe, NMBuilt 1994 · S/N EA-559 N79DSBonanza Air Ventures LLC · Mammoth Lakes, CABuilt 1982 · S/N EA-326 N79DVDiscovery Associates Inc · Midland, TXBuilt 1979 · S/N P21000233 N79FMWoods Executive Services Inc · Mineola, TXBuilt 1999 · S/N 29-0179 N79FWDaniel King Aviation LLC · Dover, DEBuilt 1979 · S/N 414A0278 N79HCBmc Group · Hawthorne, CABuilt 1990 · S/N E-2538 N79MCKruse Air LLC · Sheridan, WYBuilt 1981 · S/N E-1903 N79MMMartin Martha S · Graford, TXBuilt 1969 · S/N CJ-21 N79PKBotttomley William K · White Salmon, WABuilt 1979 · S/N 18503837 N79PPJon Gibson Co · Cameron Park, CABuilt 1980 · S/N 414A0516 N79PRHutchinson Andrew J · Gardner, KSBuilt 1970 · S/N D-9138 N79RCBach II LLC · Lafayette, LABuilt 1982 · S/N 21064697 N79SDEasi Aircraft LLC · Mount Pleasant, ARBuilt 1979 · S/N 310R1811 N79SKDouglas Cattle LLC · Douglas, AZBuilt 1977 · S/N 310R0974 N79SMTurbine Services And Consulting LLC · Bedford, TXBuilt 1995 · S/N 29-0028 N79TDFlying Bs LLC · Canby, ORBuilt 1972 · S/N 421B0325

Back to AD 86-13-04 R3