Skip to content

Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N8763XRegistered aircraftBuilt 1961 · S/N 18253163 N8763ZMacdonald John R · Vancouver, WABuilt 1968 · S/N P206-0563 N8764XAdventist World Aviation · Wilson, NCBuilt 1961 · S/N 18253164 N8766XFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVBuilt 1960 · S/N 18253166 N8767TReppond Richard · Sage, ARBuilt 1960 · S/N 52667 N8767XSmith Todd A · Duchesne, UTBuilt 1960 · S/N 18253167 N8768MRegistered aircraftBuilt 1976 · S/N 18264636 N8768RBaker Scott R · Arroyo Grande, CABuilt 1968 · S/N 18258978 N8768TCarter Douglas A · Tower, MNBuilt 1960 · S/N 52668 N8768XBeachy Phil · Bonners Ferry, IDBuilt 1960 · S/N 18253168 N8769TCopper River Airmotive LLC · Copper Center, AKBuilt 1960 · S/N 52669 N8769XOmega I Corp Inc · Middletown, DEBuilt 1961 · S/N 18253169 N876CGGreen Carlton · Carmel Valley, CABuilt 1962 · S/N 18253734 N876R76r Holdings LLC · Rockport, TXBuilt 1978 · S/N 21062844 N876SPb Limited LLC · Kalispell, MTBuilt 1957 · S/N 34356 N876SHPatton Michael D · Tygh Valley, ORBuilt 1958 · S/N 50325 N876SMNathan Smith Ministries · Belmont, NCS/N 18265957 N8770TNoble Aviators Inc · Kendallville, INBuilt 1960 · S/N 52670 N8770XRegistration Pending · Tulsa, OKRegistration pending, pending cancellationBuilt 1961 · S/N 18253170 N8771XAgainst The Wind Inc · Jasper, TNBuilt 1961 · S/N 18253171 N8772XSargent Leslie K · Chuckey, TNBuilt 1960 · S/N 18253172 N8773ZPolhamus Mark Trustee · Thompson Falls, MTBuilt 1969 · S/N P206-0573 N8774ZAero Squadron LLC · San Diego, CABuilt 1969 · S/N P206-0574 N8775XJust Jump Skydiving LLC · Laurens, NYBuilt 1961 · S/N 18253175 N8775ZB&B Auto Body LLC · Terreton, IDS/N P206-0575 N8778TLogan Ronald Thomas Jr · Newfoundland, PABuilt 1960 · S/N 52678 N8779TSkyair Express LLC · Overton, NVBuilt 1960 · S/N 52679 N8779XPannell James R · Carrabelle, FLS/N 18253179 N877CBNagaruk Nathan · Nome, AKBuilt 1974 · S/N 18263528 N8781TFereday Richard R · Mccall, IDBuilt 1960 · S/N 52681 N8781XWinterholler Robert D · Lovell, WYBuilt 1961 · S/N 18253181 N8781ZHogue Marc · Tempe, AZBuilt 1969 · S/N P206-0581 N8782TGood Altitudes Aviation LLC · Spring Hill, KSBuilt 1960 · S/N 52682 N8782XSpo Land And Cattle LLC · Springville, AZS/N 18253182 N8783ZAdventure Aircraft And Equipment LLC · Chelan, WABuilt 1969 · S/N P206-0583 N8784XHubele James R · Independence, ORBuilt 1961 · S/N 18253184 N8786XCedar Valley Air LLC · Lehi, UTS/N 18253186 N8787Q2fly Safety LLC Trustee · Azle, TXBuilt 1976 · S/N U20603539 N8787ZKing Farm Partnership · Mccrory, ARBuilt 1969 · S/N P206-0587 N8788QKochert Timothy B · Anchorage, AKBuilt 1975 · S/N U20602730 N8788XAero Cg LLC · Fresno, CABuilt 1961 · S/N 18253188 N8789XWinfreds Legacy LLC · Oneonta, ALBuilt 1961 · S/N 18253189 N8789ZParrott Charles F · Saugus, MAFirst renewal noticeBuilt 1969 · S/N P206-0589 N878CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281868 N878JWRegistered aircraftBuilt 1964 · S/N 185-0689 N8790TGray Teddy G · Scarbro, WVBuilt 1960 · S/N 52690 N8790XTyler Ronald D Jr · Harlingen, TXBuilt 1961 · S/N 18253190 N8791TStoesz Chad G · Hailey, IDBuilt 1960 · S/N 52691 N8791XJoseph Gary W · Torrance, CABuilt 1961 · S/N 18253191 N8792TFanning Fred W · Fairlawn, OHBuilt 1960 · S/N 52692

Back to AD 84-10-01 R1