Skip to content

Registered aircraft · 20,483

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.

N308SLLeibbrandt Steven E · Imperial, NEBuilt 1968 · S/N 18259354 N3090BGreen & Green Construction Co Of Grenada Inc · Grenada, MSS/N 7975 N3090FAero Missions Inc · Birmingham, ALS/N 18257190 N3090YPine Tours LLC · Wilmington, DEBuilt 1962 · S/N 18254090 N3091BRadisch Herbert R Jr · San Diego, CABuilt 1952 · S/N 7976 N3091QDank Noah S · Jacksonville, FLBuilt 1967 · S/N 18258091 N3092FJungemann Jon D · Victor, MTBuilt 1966 · S/N 18257192 N3092YGordon Robert A Jr · North Pole, AKBuilt 1962 · S/N 18254092 N3093QLitton Wade N · Townsend, MTBuilt 1967 · S/N 18258093 N3093YRegistered aircraftBuilt 1962 · S/N 18254093 N30942Polar Bear Aviation LLC · Batesville, MSBuilt 1973 · S/N 21059979 N3094QSunrise Property Maintenance Inc · Sandy, UTBuilt 1967 · S/N 18258094 N3095FGroebner David · Red Wing, MNBuilt 1966 · S/N 18257195 N3095YBatenhorst Ag LLC · Dalhart, TXBuilt 1962 · S/N 18254095 N3096FMcdowell Samuel D · Clovis, CABuilt 1966 · S/N 18257196 N3096QMorgan County Aviators LLC · Fort Morgan, COBuilt 1967 · S/N 18258096 N3096YHerrman Robin A · Connell, WABuilt 1962 · S/N 18254096 N3097YKlenke Nathan D · Seward, NEBuilt 1962 · S/N 18254097 N3098BKirsteatter Todd Paul · Kewaunee, WIBuilt 1952 · S/N 7983 N3099BStallings James K · Alva, OKBuilt 1953 · S/N 7984 N3099YPerkins Scott B · Thomas, OKFirst renewal noticeBuilt 1962 · S/N 18254099 N309GMScroggins Aero LLC · Cabot, ARBuilt 2022 · S/N 18283166 N30CTLaidley Robert F · Erie, COBuilt 1978 · S/N 182-66446 N30EWThree Zero Echo Whisky Inc · Wilmington, DEBuilt 1976 · S/N 21061412 N30FCState Alabama Forestry Commission · Florence, ALFirst renewal noticeBuilt 1982 · S/N R18201913 N30GEEagle Air Inc · Schoolcraft, MIBuilt 1976 · S/N 18265130 N30HDRegistered aircraftS/N 21063234 N30MSFlying Medical Service · Grosse Pointe, MIBuilt 1974 · S/N U20602620 N30MTMcnamara J Kevin · Cascade, IDBuilt 1977 · S/N U20604086 N30VGGeoterra Inc · Eugene, ORBuilt 1980 · S/N 21063856 N30WLSkydive Coolidge Inc · Tempe, AZBuilt 1966 · S/N P206-0275 N3100CBannon Daren · Douglass, KSBuilt 1954 · S/N 31156 N3100DDiel Mark A · Walnut Creek, CABuilt 1955 · S/N 31898 N3100FBurger Todd Richard · Helena, MTS/N 18257200 N3100RCentral Oklahoma Aviators Flying Club · Piedmont, OKBuilt 1967 · S/N 18258500 N3100SSinnissippi Aviation LLC · Beloit, WIBuilt 1964 · S/N 18255600 N3100YWhalen John F · West Ossipee, NHBuilt 1962 · S/N 18254100 N3101CFreefall Fever Inc · Edgewater, FLBuilt 1954 · S/N 30900 N3101YJazzminate Inc · La Mesa, CABuilt 1962 · S/N 18254101 N3102DOsowski Christopher J · Anchorage, AKBuilt 1955 · S/N 31900 N3102FWhitfield Timothy D · Fairfield, NCBuilt 1966 · S/N 18257202 N3103CBay Kelly M Trustee · Glennallen, AKBuilt 1954 · S/N 30902 N3103FJorgensen Bryan K · Kingston, GABuilt 1967 · S/N 18258103 N3104FFlorida Armstron Boring LLC · Coeur D Alene, IDBuilt 1966 · S/N 18257204 N3104QSauer Jason DBA · Glen Ullin, NDBuilt 1967 · S/N 18258104 N3105DHenderson Raymond N · Kosciusko, MSBuilt 1955 · S/N 31903 N3105SMorgan A Douglas · Madera, CABuilt 1964 · S/N 18255605 N3105YOakley James H · Spring Valley, CABuilt 1962 · S/N 18254105 N3106CPetrie Michael · Chugiak, AKBuilt 1954 · S/N 30905 N3106QStiens Fred T · Moses Lake, WAS/N 18258106

Back to AD 84-10-01 R1