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.

N9412ZHelms Stephen G · Anchorage, AKBuilt 1982 · S/N U20606473 N94148Gates Don · Richmond Hill, GABuilt 1974 · S/N 21060519 N9415CSouthwest Plane Holdings LLC · Kalispell, MTBuilt 1983 · S/N T30300176 N9415QMichael D Scott · Los Gatos, CABuilt 1972 · S/N CE-362 N9415SWasson-Ece Instrumentation · Fort Collins, COBuilt 1965 · S/N TE-41 N94168Sullivan Sandra E · Maple Valley, WABuilt 1977 · S/N 18503285 N9418QBonanza Partners LLC · Taos Ski Valley, NMBuilt 1972 · S/N E-307 N941AChalk 2 Inc · Apple Valley, CABuilt 1965 · S/N D-7865 N941CDAjn Air LLC · Visalia, CAS/N 0270 N941SENorthwest Movers LLC · Olympia, WABuilt 2007 · S/N 2312 N941TCKupau Inc · Kailua Kona, HIBuilt 2002 · S/N 40049 N94202Gilsdorf David R Trustee · Pleasant Hill, MOBuilt 1974 · S/N 21060536 N94203Frasier Air Inc · Tulsa, OKBuilt 1974 · S/N 21060537 N94206Andrews Gordon Bruce · Ellicott City, MDBuilt 1974 · S/N 21060539 N9420MSideline Services LLC · Pearland, TXBuilt 1970 · S/N 21059320 N9420RStarr William E · Eagle River, AKBuilt 1985 · S/N U20606860 N9420SBaumann James R · Muskogee, OKS/N D-8015 N94211Jskp Enterprises LLC · Dover, DEBuilt 1974 · S/N 21060542 N94219Feenstra Patrick · Scottsdale, AZBuilt 1977 · S/N 18503291 N9421SFugate Kirk A · El Dorado Springs, MOBuilt 1965 · S/N D-8017 N94227Dodson International Parts Inc · Rantoul, KSBuilt 1974 · S/N 21060549 N9422KFaulkner Harry E Jr · Bethel, AKS/N U20604395 N9422SWindwalker Adventures LLC · Scottsdale, AZBuilt 1965 · S/N D-8020 N94237Brett Ryan J · Wasilla, AKBuilt 1977 · S/N 18503294 N9423STlc Aero LLC · Magnolia, TXBuilt 1965 · S/N D-8018 N94244Bryant Kenneth D · Black Diamond, WAS/N 21060559 N94260Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1977 · S/N 18503296 N94263Hitch Aviation Inc · Malta, MTBuilt 1974 · S/N 21060569 N94266Braun Kristy J · Fairbanks, AKBuilt 1977 · S/N 18503297 N94267Hop Props LLC · Houston, TXBuilt 1974 · S/N 21060571 N9426KO Max Aviation · Willowbrook, ILBuilt 1974 · S/N 21060572 N94285Great Lakes Enterprises · Heron, MTBuilt 1974 · S/N 21060584 N9428GSecond Wind Aviation Corp · Friday Harbor, WABuilt 1970 · S/N U20601628 N9429QBuck Hollow Investments LLC · Austin, TXBuilt 1972 · S/N TH-200 N942CPV1 Holdings LLC · Morgan Hill, CABuilt 1977 · S/N TK-61 N942JMPogany Steve C · Chugiak, AKBuilt 1976 · S/N U20603365 N942SAWalker John A · Kotzebue, AKS/N TU2060553 N942SMMackie Jonathan M · Manistique, MIBuilt 1969 · S/N T210-0416 N942SWVascoe Jeffre M · Houston, TXBuilt 1981 · S/N 421C1025 N942VEndeavor Enterprises LLC · Alta Loma, CAS/N E-715 N9430QHoyt Stuart T · Raleigh, NCBuilt 1972 · S/N D-9316 N9431QN9431q LLC · Round Rock, TXBuilt 1972 · S/N CE-365 N9431SBurgdorf Dale A · Plano, TXBuilt 1965 · S/N D-8021 N9432MRound Table Aviation LLC · Munster, INFirst renewal noticeBuilt 1970 · S/N 21059332 N9432QKnh LLC · Bozeman, MTBuilt 1972 · S/N E-310 N9433MDels Inc · Mountain Home, ARBuilt 1970 · S/N 21059333 N9434NAnderson Thomas R · Renton, WABuilt 1981 · S/N 18504355 N9436MIkg Air LLC · Page, AZBuilt 1981 · S/N 20700689 N9436SShrauner Harry Scott Trustee · Elkhart, KSS/N TE-48 N9438MIdaho Transportation Department · Boise, IDBuilt 1978 · S/N U20604546

Back to AD 86-13-04 R3