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.

N2417CW & K Aviation LLC · Omro, WIS/N 30717 N2417QMcgough Julie Eileen · Red Oak, TXS/N 18257617 N2417RJohary Aviation Inc · Apopka, FLS/N 18255517 N2417XGerding Thomas P · Philomath, ORBuilt 1965 · S/N 18256317 N2418CBlythe Anne T · Paso Robles, CABuilt 1954 · S/N 30718 N2418GSunset Cay Orc Partners LLC · Key Largo, FLS/N 51718 N2418XPoessel Frank George Jr · East Bernard, TXBuilt 1965 · S/N 18256318 N2419FMartinez Rudy J · Wasilla, AKBuilt 1965 · S/N 18051619 N2419GBig Sky Aviation LLC · Kapaau, HIBuilt 1958 · S/N 51719 N2419QScholl Steven G · Bluffton, SCBuilt 1966 · S/N 18257619 N2419RLynch Gerald A · Santa Barbara, CABuilt 2000 · S/N 18280927 N241AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281182 N241DAMonard Larry R · Anadarko, OKBuilt 1960 · S/N 57563 N241JJN241jj LLC · Louisville, KYBuilt 2025 · S/N 18283313 N241ME#430b LLC · Bruce Township, MIBuilt 2000 · S/N 18280761 N241SRLeman Joseph A · Anchorage, AKBuilt 1965 · S/N 18256316 N24201Suhr Douglas Henry Jr · Oil City, PABuilt 2007 · S/N 18281954 N2420SNighthawk Inc · Dallas, TXBuilt 1962 · S/N 18051139 N2421CGeisler Mark · Dallas, TXBuilt 1954 · S/N 30721 N2421FDeckload Aviation LLC · Kodiak, AKBuilt 1965 · S/N 18051621 N2421QAristigue Brothers LLC · Sierra Vista, AZBuilt 1966 · S/N 18257621 N2421XMills Michael N Jr · Granbury, TXBuilt 1965 · S/N 18256321 N24227Styer Michael J · Amarillo, TXBuilt 1955 · S/N 31504 N2422RAbecca Corp · Jackson, MIBuilt 1964 · S/N 18255522 N2423FSwalling Paul C · Anchorage, AKBuilt 1965 · S/N 18051623 N2423SAircraft Sales LLC · Caledonia, MIBuilt 1976 · S/N 21061275 N2423XCarrier Peter · Skowhegan, MEBuilt 1965 · S/N 18256323 N2424Q24q Inc · Cedar City, UTBuilt 1966 · S/N 18257624 N2424RCurlee Derek · Yoakum, TXBuilt 1964 · S/N 18255524 N2425CGiovanini Terry L · Bozeman, MTBuilt 1979 · S/N 18267471 N2425GMccune Charles · Metamora, ILBuilt 1959 · S/N 51725 N2425RDietze Weldon W · Seguin, TXBuilt 1964 · S/N 18255525 N2425SPark Sung S · Marana, AZBuilt 1976 · S/N 21061276 N2426RRiley Aerospace LLC · Sebastian, FLBuilt 1964 · S/N 18255526 N2426XColwell Patrick R Jr · Medford, WIBuilt 1965 · S/N 18256326 N2427GMcneil Jesse M · Central, AKBuilt 1959 · S/N 51727 N2428CRegistered aircraftBuilt 1954 · S/N 30728 N2428GBackcountry Guys LLC · Prescott, AZBuilt 1959 · S/N 51728 N2428RAltimeter Inc · San Marcos, TXBuilt 1964 · S/N 18255528 N2428XBiggs Clifford G · Washington, UTBuilt 1965 · S/N 18256328 N2429GSkydive Florida Keys Inc · Summerland Key, FLS/N 51729 N2429XMontpetit Steven W · New Richmond, WIBuilt 1965 · S/N 18256329 N242AFAlagar Volare LLC · Anna, TXBuilt 2003 · S/N 18281183 N242EMDay Grain Co Inc · Braman, OKBuilt 1974 · S/N 18263224 N242MEMike Echo Ventures LLC · Coral Gables, FLBuilt 2000 · S/N 20608112 N242RDTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283334 N242USilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608242 N242VPirshafiey Nasser Charles · Trabuco Canyon, CABuilt 1965 · S/N T210-0004 N2430FTopaz LLC · Anchorage, AKBuilt 1965 · S/N 18051630 N2431GGulf Coast Helicopters Inc · Pearland, TXBuilt 2000 · S/N 18280681

Back to AD 84-10-01 R1