Skip to content

Registered aircraft · 1,686

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:71-09-07-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:71-09-07-R1') 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:71-09-07-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:71-09-07-R1')
  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:71-09-07-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:71-09-07-R1')
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.

N813DMAp-1 LLC · Newman Lake, WABuilt 1975 · S/N 21060946 N813SWWolff Scott · Missoula, MTBuilt 1979 · S/N U20605296 N8141GBitter Creek Investments LLC · Cascade, IDS/N 21059441 N8159MHowell Andrew · Pinedale, WYS/N 21062032 N8183MHaman Peter A · Douglas, WYBuilt 1977 · S/N 21062033 N81DTKbk Aviation LLC · Youngsville, LAS/N 21064519 N81KCCraigo Keith A · Addison, TXBuilt 1981 · S/N 21064386 N820AHBuffaloe Thomas N · Mancos, COBuilt 1981 · S/N U20606123 N8225QCartoflight Inc · Willoughby, OHBuilt 1976 · S/N U20603109 N8237MMiddle Tennessee State University · Murfreesboro, TNBuilt 1969 · S/N 21059237 N8249MRancho Bonito LLC · Oxnard, CABuilt 1977 · S/N 21062039 N8260MCloud Dancer LLC · El Paso, TXS/N 21062040 N8261MZaller Anthony J · Phoenix, AZBuilt 1970 · S/N 21059261 N8263GFitzpatrick Dennis B · Mccall, IDBuilt 1977 · S/N U20603784 N8264QMoody Bible Institute Of Chicago · Spokane Valley, WABuilt 1975 · S/N U20603125 N8271MBoyd David R · San Jose, CAS/N 21062041 N8274QBravo Delta II LLC · Steamboat Springs, COBuilt 1976 · S/N U20603135 N8275QAbel Derek R · Rio Vista, CABuilt 1976 · S/N U20603136 N8277MBlalock Paul T · Longview, TXBuilt 1970 · S/N 21059277 N8281ZSpearfish Aviation Inc · Summerset, SDS/N U20604116 N8286M3 Jc LLC · Phoenix, AZBuilt 1970 · S/N 21059286 N828RJNielsen Ron E · Lindon, UTS/N 21063836 N8292MAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 21059292 N8293QBaker Marianne J · Raeford, NCBuilt 1976 · S/N U20603154 N8352QUnited Indian Missions DBA · Tucson, AZBuilt 1976 · S/N U20603213 N8366CWinter Garden Equipment LLC · Lewes, DEBuilt 1982 · S/N U20606603 N8386M213tz LLC · Hailey, IDBuilt 1978 · S/N U20604520 N8409QFrey David G Jr · Grand Rapids, MIBuilt 1976 · S/N U20603269 N841JLMarks Stephen M · Monument, COBuilt 1967 · S/N T210-0330 N8424WExtra Equipment Inc · Stuart, FLBuilt 1979 · S/N 21063732 N8439GSmith Air LLC · Cascade, IDS/N U20603790 N843YTTrue Drilling LLC · Casper, WYBuilt 1979 · S/N 21063334 N8462QPahrump Aviation LLC · Las Vegas, NVS/N U20603320 N8463QSmith James M · Star, IDBuilt 1976 · S/N U20603321 N8475MSpess Drilling Co Inc · Cleveland, OKBuilt 1977 · S/N 21062046 N8479QLake Airways Management LLC · Hazelhurst, WIBuilt 1976 · S/N U20603337 N8482QGregg Flying Service Inc · Durango, COBuilt 1976 · S/N U20603340 N8495MCourtney Aviation LLC · Columbia, CAS/N 21062048 N84SJLabelle Gregory D Trustee · Newbury Park, CABuilt 1984 · S/N 21064867 N8506QBell Robert C · Colby, KSS/N U20603363 N8523QLifetime Adventures LLC · Bellevue, MIBuilt 1976 · S/N U20603379 N8526QKenworthy Winston C · Odessa, TXBuilt 1976 · S/N U20603382 N8546QBlack Andrew J · Broomfield, COBuilt 1976 · S/N U20603402 N8576QThompson Robert Lee · Moore, OKBuilt 1976 · S/N U20603432 N8580QBald Eagle Aviation LLC · Oakley, UTBuilt 1976 · S/N U20603436 N858BBEchelon Group Inc · Boise, IDBuilt 1979 · S/N 21063277 N858JAAms Aviation LLC · South Bend, INBuilt 1976 · S/N U20603437 N8598QTolley Samuel M · Rangely, COBuilt 1976 · S/N U20603453 N859ALAms Aviation LLC · South Bend, INBuilt 1979 · S/N U206-04888 N85PEMidwest Airmotive Inc · Mount Sterling, KYBuilt 1975 · S/N U20602774

Back to AD 71-09-07 R1