Skip to content

Registered aircraft · 25,370

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N57559N57559 LLC · Elgin, ILBuilt 1984 · S/N 24-1462 N5756KMoquin Thomas A · Hampshire, ILBuilt 1984 · S/N 24-1463 N5756QDominguez Juan · Austin, TXBuilt 1965 · S/N 3080 N5757EFlex Air Inc · San Diego, CABuilt 1978 · S/N 17271935 N5758JBatchelder Wesley · Palacios, TXBuilt 1980 · S/N 17273833 N5758QAviation Forza Inc · Pompano Beach, FLS/N 3081 N5759BTjelle Michael J · Coal City, ILBuilt 1984 · S/N 24-1465 N575DSGotfredson Allen S · Ten Sleep, WYBuilt 1975 · S/N 885-75 N575TDDahl Russell · Nashua, MTBuilt 1976 · S/N 17268034 N5760QHill Jonathan Troy · Taylorsville, KYBuilt 1965 · S/N 3082 N5760RChapel Hill Flying Club Inc DBA · Sanford, NCBuilt 1984 · S/N 24-1466 N5760TBradley Brent E · Arvada, COBuilt 1984 · S/N 24-1467 N5761GNelson Ken · Caledonia, WIBuilt 1980 · S/N 0831 N5761ZHannibal Aviation LLC · Stamford, CTBuilt 1980 · S/N 0834 N57627Foothill Sport Aviation LLC · Cameron Park, CABuilt 1973 · S/N 986-74 N57628Ridder Thomas · Leoti, KSBuilt 1973 · S/N 619-74 N57629Hauf Daniel R · Jack, ALBuilt 1973 · S/N 408-74 N5762BAssociated Aircraft LLC · San Diego, CABuilt 1980 · S/N 0833 N5762DNavar Thomas R · El Paso, TXBuilt 1981 · S/N 1004 N5762GBrown Patrick T Trustee · Osceola, WIBuilt 1981 · S/N 1003 N5762QCross Brian K · Winters, CABuilt 1965 · S/N 3083 N57634Dye David V Trustee · Wasilla, AKBuilt 1973 · S/N 613-74 N57635Robertson Trevor W · Spokane, WABuilt 1973 · S/N 124-74 N5763EVilla Rafael O · Miami, FLBuilt 1978 · S/N 17271936 N5763LHylander Jared R · Elizabeth City, NCBuilt 1984 · S/N 24-1470 N5763QMach 1 Air Services LLC · Los Angeles, CABuilt 1965 · S/N 740 N5763XStatewide Transportation LLC · Oklahoma City, OKBuilt 1984 · S/N 24-1473 N5763YLane Phillip C · Peru, INBuilt 1984 · S/N 24-1474 N57640Kramer Alex H · Louisville, KYBuilt 1973 · S/N 283-74 N57641Bruch Zweit F · Whitewood, SDBuilt 1973 · S/N 623-74 N57645Williams Shelia H · Headland, ALBuilt 1973 · S/N 410-74 N57646Turner Steven G · Clearwater, KSBuilt 1973 · S/N 991-74 N57649Jagers Ed Dean · Lamar, COBuilt 1973 · S/N 620-74 N5764HSleepytime Pllc · Eagle, IDBuilt 1984 · S/N 24-1477 N5764JLevy Laurent · Quakertown, PABuilt 1984 · S/N 24-1478 N5764KDevine Robert L · Condon, ORBuilt 1984 · S/N 24-1479 N5764QJas Aircraft LLC · Summerland Key, FLS/N 3084 N57651Maxeiner Kenneth · Lake Charles, LABuilt 1984 · S/N 24-1484 N57654Mclaughlin John R · Moravia, NYBuilt 1973 · S/N 413-74 N57655Bekanich Jason · Camden, NCBuilt 1973 · S/N 993-74 N57656Haan Arthur G II · Indianapolis, INBuilt 1974 · S/N 622-74 N57657Beitel Theodore C · Higden, ARBuilt 1973 · S/N 127-74 N57658Datum Air Inc · Saint Matthews, SCBuilt 1984 · S/N 24-1486 N57659Progressive Air Inc · Janesville, WIBuilt 1973 · S/N 624-74 N57660Parks Dustin M · Murray, KYBuilt 1973 · S/N 414-74 N57661Hornbeck Richard L · Bowdoinham, MEBuilt 1973 · S/N 996-74 N57662August Aero LLC · Kalispell, MTBuilt 1973 · S/N 625-74 N57663Swim Charles W · Bozman, MDBuilt 1984 · S/N 24-1489 N57664Jarosz Jeffrey J · Newton, WIBuilt 1974 · S/N 437-74 N57666Hoon David M · Wolf Creek, MTS/N 626-74

Back to AD 80-25-07 R1