Skip to content

Registered aircraft · 10,639

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:99-01-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:99-01-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:99-01-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:99-01-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:99-01-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:99-01-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.

N3130MCarlblom Boyd W · Eveleth, MNBuilt 1947 · S/N 12-1818 N3131ZPralle Jeffory K · Wasilla, AKBuilt 1959 · S/N 22-7076 N3134MDrummond Dana S · Anchorage, AKBuilt 1947 · S/N 12-1830 N3135MWilson Brian W · Palmer, AKS/N 12-1829 N3136MEms Ronald D · Portland, ORBuilt 1947 · S/N 12-1808 N3136ZSchafer Patrick A · Marietta, OHBuilt 1959 · S/N 22-7080 N3138MSpoden Thomas R · Maple Lake, MNBuilt 1947 · S/N 12-1821 N313GWWright George E Jr · Homestead, FLBuilt 1956 · S/N 18-5260 N313TBlackerby Alexander · Eola, TXS/N 18-2427 N3140ZHoyt Kenneth B · Marion, KSBuilt 1959 · S/N 22-7084 N3141ZKumbier Jenene R · Maxwell, IABuilt 1959 · S/N 22-7086 N3143ZChristian Edward A · Evans, GABuilt 1959 · S/N 22-7088 N3144ZWasilowski Richard P · Arlington, WABuilt 1959 · S/N 22-7089 N3146TRegistered aircraftBuilt 1947 · S/N 12-3217 N3147ZNeudorf Robert H · Alamogordo, NMBuilt 1959 · S/N 22-7094 N3148MThoft Matthew M · Wasilla, AKBuilt 1947 · S/N 12-1835 N3151MWrong Brothers Aviation LLC · Webster, MNBuilt 1947 · S/N 12-1837 N3151ZOld Crow Flyers LLC · Mooresville, NCBuilt 1959 · S/N 22-7098 N3152MAce Aeromotive Inc · Miami, FLBuilt 1947 · S/N 12-1839 N3152ZMoultrie Zachariah D M · Grass Valley, CABuilt 1959 · S/N 22-7096 N3154MBurnett Martin · Greenbrier, ARBuilt 1947 · S/N 12-1841 N3155MManrique Rick E · Palmer, AKFirst renewal noticeBuilt 1947 · S/N 12-1857 N3155ZKrejci Dwight D · Wheatland, WYBuilt 1959 · S/N 22-7102 N3156ZSale Reported · Wellsville, UTSale reported, canceledBuilt 1959 · S/N 22-7103 N3157MRegistered aircraftS/N 12-1890 N3157ZIvy James E · Alba, TXS/N 22-7104 N3159ZPepin Daniel J · King Salmon, AKBuilt 1959 · S/N 22-7106 N3161ZTyner James A · Bend, ORBuilt 1959 · S/N 22-7109 N3162MWilson John R · Fayetteville, NCBuilt 1947 · S/N 12-1842 N3164MCaskey Martin K · Paso Robles, CABuilt 1947 · S/N 12-2005 N3165ZSmith Kenneth W · Bedford, INBuilt 1959 · S/N 22-7116 N3166MAdam Charles D · Hayden, IDBuilt 1947 · S/N 12-2001 N3166ZDarr J L III · Trinity, NCBuilt 1959 · S/N 22-7117 N3167MBunn Benjamin D · Winchester, VABuilt 1947 · S/N 12-1599 N3168MHebrink Benjamin W · Fairbanks, AKBuilt 1947 · S/N 12-1847 N3169ZBixler Tyke L · Massillon, OHBuilt 1959 · S/N 22-7120 N316TPanther Rock LLC · Fluvanna, TXBuilt 1953 · S/N 18-2430 N3170ZGarrity Frank B · Durham, CABuilt 1959 · S/N 22-7122 N3171MHubner Matthew B · Napa, CABuilt 1947 · S/N 12-1852 N3172ZSpitzer Anthony L · Kalona, IABuilt 1959 · S/N 22-7124 N31741Parks Eric · Mount Dora, FLBuilt 1941 · S/N 6584 N3174MSouthern Cross Aviation Inc · Wilmington, DES/N 12-1851 N3176ZKielty Ronald · Ocala, FLBuilt 1959 · S/N 22-7128 N3177MMayo William M · Wahpeton, NDBuilt 1947 · S/N 12-1894 N3177ZMorris David P · Inverness, FLS/N 22-7131 N317DFSchachle Robert G Jr · Wasilla, AKBuilt 1947 · S/N 12-1649 N3181MBiondich Dennis A · Rubicon, WIBuilt 1947 · S/N 12-2021 N3182ZArnt Aerial Spraying Inc · Worthington, MNBuilt 1959 · S/N 18-7173 N3183ZPancoast John M · Palmer, AKBuilt 1959 · S/N 18-7174 N3185MEva Tn LLC · Wilmington, DEBuilt 1947 · S/N 12-1866

Back to AD 99-01-05 R1