Skip to content

Registered aircraft · 40,473

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-04-03-R2') 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-04-03-R2') 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-04-03-R2')
    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-04-03-R2')
  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-04-03-R2')
  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-04-03-R2')
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.

N461HHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1990 · S/N 1460 N461JGGosch Jerry L · Missouri City, TXBuilt 2005 · S/N 22019 N461PMMcmillion John T Trustee · Grand Marais, MNBuilt 1946 · S/N 12-461 N461RKTolstrup Dustin G · Wasilla, AKS/N 001 N461RMRr&D Lp · Fayetteville, NCBuilt 1968 · S/N 17257043 N461TJSharmouj Raymound · Christiansted, VIFirst renewal noticeBuilt 1970 · S/N 17259114 N46200Larsen Delaine E · Wakarusa, INBuilt 1968 · S/N 17257102 N46201Lakes Area Aviation LLC · Little Falls, MNBuilt 1968 · S/N 17257103 N46203Avian Leasing LLC · Bremerton, WABuilt 1968 · S/N 17257105 N46204Ms Tango LLC · Phoenix, AZS/N 17257106 N46205Jeanes Michael W · Newbury Park, CABuilt 1968 · S/N 17257107 N46210Cloud Dancer Aviation Inc · Deland, FLBuilt 1968 · S/N 17257111 N46211Carver Clarence K Trustee · Lutz, FLS/N 17257112 N46214Greaves Ricky W · Arlington, TXBuilt 1968 · S/N 17257114 N46219Diehl Samuel A · Hamptonville, NCBuilt 1968 · S/N 17257116 N4621DW Tech Consulting Inc · Wilmington, DEBuilt 1979 · S/N 17272316 N4621RVides Jose F · La Puente, CABuilt 1966 · S/N 28-21370 N46221Collins Kellie Lynn · Muskegon, MIBuilt 1968 · S/N 17257117 N46226Tye Darren · Tulia, TXBuilt 1968 · S/N 17257120 N46227Lindsay Lori K · Kenai, AKBuilt 1968 · S/N 17257121 N4622RZimmerschield Paul T · Sedalia, MOBuilt 1966 · S/N 28-21372 N46230Owen Collins · Toccoa, GABuilt 1968 · S/N 17257123 N46243Goracke Terry R · Junction City, ORS/N 162 N46245Fedor Allen L · Holdingford, MNBuilt 1968 · S/N 17257132 N46246Pidgeon J Everett III · Millington, TNBuilt 1968 · S/N 17257133 N46250Lange William A Jr · Interlaken, NYBuilt 1968 · S/N 17257135 N46251Kiley Lawson P · Gamaliel, ARBuilt 1968 · S/N 17257136 N46254Schmidt Keven W · Madison, WIBuilt 1968 · S/N 17257139 N46255Simpson Chad J · Dresser, WIBuilt 1968 · S/N 17257140 N46256Hartford Air LLC · Gahanna, OHBuilt 1968 · S/N 17257141 N4625GOpal Aviation LLC · Miami, FLBuilt 1979 · S/N 17273272 N46262Lautner Elden B · Kaleva, MIBuilt 1974 · S/N 17264179 N46267Kuzmick Paul Jr · Livingston, NJBuilt 1968 · S/N 17257147 N46269Fox Victor Aviation LLC · Newnan, GAFirst renewal noticeBuilt 1968 · S/N 17257148 N4626RAlatis Nicholas C · Cincinnati, OHFirst renewal noticeBuilt 1965 · S/N 28-21377 N46276Johnson Lawrence H · Ava, MOBuilt 1968 · S/N 17257150 N4627FGahan Brian C · Cary, ILBuilt 1976 · S/N 28-7715057 N4627RMayo Craig · Hart, MIBuilt 1966 · S/N 28-21378 N4627YReichel Karl M · Cook, MNBuilt 1971 · S/N 18-8943 N46281Cabrera Ramon F · West New York, NJS/N 17257153 N46282Maggie Of The Emerald Coast LLC · Panama City, FLBuilt 1968 · S/N 17257154 N46283West Kentucky Flyers Corp · Murray, KYBuilt 1968 · S/N 17257155 N46284Howard David D · Winner, SDBuilt 1968 · S/N 17257156 N46287N46287 LLC · Chehalis, WABuilt 1968 · S/N 17257157 N46288Sullivan Patrick J · Salt Lake City, UTBuilt 1968 · S/N 17257158 N4628RTydc Air LLC · Bloomington, MNBuilt 1965 · S/N 28-21379 N46291Sikorsky Igor I III · Kittery, MEBuilt 1968 · S/N 17257160 N46292Globetek Aviation LLC · Raymond, MEBuilt 1968 · S/N 17257161 N46293Keefer Terry · La Verne, CABuilt 1968 · S/N 17257162 N46299Van Anda Aviation LLC · Apopka, FLBuilt 1974 · S/N 17264180

Back to AD 80-04-03 R2