Skip to content

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N980GCAir Kraft Spraying Inc · Timber Lake, SDBuilt 1971 · S/N 39-119 N980PThompson Chadd E · Carlyle, ILBuilt 1964 · S/N 26-71 N9811DWilson Jackson R F · Talkeetna, AKS/N 22-6698 N9814DGupton Scott W · Prescott Valley, AZBuilt 1959 · S/N 22-6701 N9815PTucson Soaring Club Inc · Sahuarita, AZBuilt 1975 · S/N 25-7556129 N9816DWierda Evert T · Manhattan, MTBuilt 1959 · S/N 22-6703 N9819PHolder R William · Pittsfield, PABuilt 1975 · S/N 25-7556136 N9824PKnutson Wayne R · Thompson, NDBuilt 1975 · S/N 25-7556142 N9827DQuality Aviation Inc · Marana, AZS/N 22-6717 N9827PSmith Terry L · Cedar Hill, TNS/N 25-7556146 N982WKnox Warren Henry · Santa Cruz, CABuilt 1962 · S/N 22-9219 N9830PHolmgren Michael G · Kulm, NDBuilt 1975 · S/N 25-7556148 N9831DHiginbotham Larry L · Littleton, COBuilt 1959 · S/N 22-6722 N9832DNimmick Robert A · Three Forks, MTBuilt 1959 · S/N 22-6723 N9835DWalton Ross F · Bardstown, KYBuilt 1966 · S/N 24-4497 N9836DBuffo Perry P · Berlin, NJBuilt 1959 · S/N 22-6727 N9837DDavis Scott · Bingham, NEBuilt 1959 · S/N 22-6728 N9839DMason Andrew D · Russell, IABuilt 1959 · S/N 22-6730 N9840DWard Brian P · Vonore, TNBuilt 1959 · S/N 22-6731 N9842DSnider Scott E DBA · Turner, MTS/N 22-6733 N9843DSlaughter Don Wayne · Farmville, NCBuilt 1959 · S/N 22-6734 N9844PKnutsen Wayne R · Thompson, NDBuilt 1975 · S/N 25-7556163 N9845DAhmad Abdul Moyeed · Aiken, SCBuilt 1951 · S/N 22-6737 N9846PKenmore Crew Leasing Inc Trustee · Bellingham, WAS/N 25-7556165 N984AUlrich Kenneth B · Mosinee, WIBuilt 1951 · S/N 22-296 N984WBRichard Waldren LLC · Newberg, ORBuilt 1961 · S/N 22-8398 N985AColangione Rocco R · Troy, NYBuilt 1951 · S/N 22-297 N985SCKilo Aviation LLC · Oregon City, ORBuilt 2025 · S/N 4496605 N98749Howes Richard D · Mountain Home, IDBuilt 1978 · S/N 44-7995104 N9876SBlack Forest Soaring Society Inc · Monument, COS/N 25-4116 N9878PSeattle Glider Council Inc · Bellevue, WABuilt 1975 · S/N 25-7556217 N9879PPetersen Conrad · Kenmare, NDBuilt 1975 · S/N 25-7556208 N987NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 4496591 N987SCJuliet Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 4496498 N9881PSale Reported · Spartanburg, SCSale reportedBuilt 1975 · S/N 25-7556210 N9883PMinden Soaring Club Inc · Minden, NVBuilt 1975 · S/N 25-7556211 N988NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 4496592 N988TPOdendahl Thomas H Jr · Saint Augustine, FLBuilt 1968 · S/N 24-4783 N9892PArizona Soaring Inc · Maricopa, AZBuilt 1975 · S/N 25-7556215 N9896PLees Aerial Spraying Inc · Aberdeen, IDBuilt 1975 · S/N 25-7556219 N9897PMississippi State University Soaring Club Inc · Mississippi State, MSBuilt 1975 · S/N 25-7556220 N989FLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496651 N98NTTurner Lawrence L · Fallon, NVBuilt 1965 · S/N 30-927 N98PPMedia Stew LLC · Carson City, NVBuilt 1965 · S/N 27-2872 N9900PWhitley Aviation LLC · Altoona, ALBuilt 1975 · S/N 36-7560002 N9901PWilliams Fertilizer Services LLC · Oregon, MOBuilt 1975 · S/N 36-7560003 N9904PRose Dale · Americus, GABuilt 1975 · S/N 36-7560007 N9911LRitter Timothy D · Billings, MTBuilt 1966 · S/N 24-4524 N9911PMid Continent Aircraft Corp · Hayti, MOBuilt 1975 · S/N 36-7560019 N9913RBridges James · Chico, TXBuilt 1965 · S/N 24-4255

Back to AD 85-02-05 R1