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.

N73ZFlying Rocks LLC · Sparkill, NYFirst renewal noticeBuilt 1964 · S/N 30-359 N7400DSmith Dwight S · Ann Arbor, MIBuilt 1957 · S/N 22-5160 N7400KLopez Lionel A · Wasilla, AKBuilt 1950 · S/N 20-308 N7400YWright Amos L Jr · Enterprise, ALBuilt 1964 · S/N 30-457 N7402YN5746u LLC · Dover, DES/N 30-460 N7403KAnderson Jeff · Lewisville, NCBuilt 1950 · S/N 20-311 N7404KRegistration Pending · Eagle River, AKRegistration pendingBuilt 1950 · S/N 20-312 N7404PWhisler Greg A · Lincoln, NEBuilt 1961 · S/N 24-2589 N7404YSlowpoke Air LLC · Palm Harbor, FLBuilt 1964 · S/N 30-463 N7405KPedersen Larry A · Waynesboro, PAS/N 20-314 N7405PClassic World Holdings LLC · Wilmington, DES/N 24-2590 N7406PAviation Collective LLC · Fort Worth, TXBuilt 1961 · S/N 24-2593 N7406YTucker Engineering Associates Inc · Locust, NCS/N 30-465 N7408DTobin John C · Olympia, WAS/N 22-5169 N7408KCapps Steven · Newcastle, OKBuilt 1950 · S/N 20-317 N7408PJeffrey Thomas James · Crestwood, KYBuilt 1961 · S/N 24-2595 N7409DBartlett Donald R · Weirsdale, FLBuilt 1957 · S/N 22-5170 N7409PPeters Gordon J · Salem, ORBuilt 1961 · S/N 24-2596 N7409ZFinger Lakes Soaring Club Inc · Dansville, NYFirst renewal noticeBuilt 1965 · S/N 25-3375 N7410DHampton Michael D · Marshfield, MOFirst renewal noticeBuilt 1957 · S/N 22-5171 N7410YDuncan Paul J · Bartlett, TNBuilt 1964 · S/N 30-472 N7411DMclain Joseph L · Louisville, KYBuilt 1957 · S/N 22-5172 N7412KBailis David P · Bethlehem, PABuilt 1950 · S/N 20-322 N7412PEspyess Aviation LLC · Sylvania, OHBuilt 1961 · S/N 24-2600 N7413DDraper Scott · Rutland, VTBuilt 1957 · S/N 22-5174 N7413KBecerra Edward Jr · Mount Pleasant, WIBuilt 1950 · S/N 20-323 N7413YOutka Air LLC · Aberdeen, SDBuilt 1964 · S/N 30-475 N7414DCulver Robert D · Sacramento, CABuilt 1957 · S/N 22-5175 N7416PDavenport Jimmy J · Hayesville, NCBuilt 1961 · S/N 24-2604 N7417DUnderwood Todd M · Foley, ALBuilt 1957 · S/N 22-5178 N7417KHulse Anthony G · Wasilla, AKBuilt 1950 · S/N 20-328 N7417PWhitewater Aviation Inc · Harrison, OHBuilt 1961 · S/N 24-2605 N7418YArmbrister Justin R · Blue Ridge, TXBuilt 1964 · S/N 30-482 N74199Aldrich Curtiss R · Aguila, AZBuilt 1965 · S/N 27-3026 N7419PBollfrass William Henry III · Rhinelander, WIBuilt 1961 · S/N 24-2607 N741TJJackson Thomas R Jr · Spearfish, SDBuilt 1964 · S/N 30-477 N7420KGonzales Kevin F · Alger, OHBuilt 1950 · S/N 20-330 N7420PTurner Bryan R · Corinth, TXBuilt 1961 · S/N 24-2608 N7420YLegacy Aviation Inc · Stuart, FLBuilt 1964 · S/N 30-484 N7421YHinkle Anthony Gray · Mineola, TXBuilt 1964 · S/N 30-486 N7422DEvans Clyde Joseph · Muscatine, IABuilt 1957 · S/N 22-5183 N7422ZFarm Air Inc · Astoria, ILBuilt 1965 · S/N 25-3399 N7423KStricker Edwin C · Lucerne Valley, CABuilt 1950 · S/N 20-333 N7424DBradley Bane L · Lyndonville, NYBuilt 1957 · S/N 22-5185 N7424KSpalding Michael A · Ahoskie, NCBuilt 1950 · S/N 20-334 N7424PHutcheson Raymond E · Lawrence, INBuilt 1961 · S/N 24-2612 N7425PRiffle Christopher B · Altus, OKBuilt 1961 · S/N 24-2613 N7426PNehus Christopher J · Camarillo, CABuilt 1961 · S/N 24-2614 N7429DTomporowski Robert C · Piesco, NYBuilt 1957 · S/N 22-5192 N7429KEarley Bruce H · Buckley, WAS/N 20-339

Back to AD 85-02-05 R1