Skip to content

Registered aircraft · 40,474

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.

N13077Raborn Albert F · Collinsville, VABuilt 1973 · S/N 17262478 N13078Nichols Patrick C · Fairview, NCBuilt 1973 · S/N 17262479 N13079Great Lakes Air Inc · Alpena, MIBuilt 1973 · S/N 17262480 N13081Eagle East Aviation Inc · North Andover, MABuilt 1973 · S/N 17262481 N13083Cloud Surfer N13083 LLC · Helena, MTBuilt 1973 · S/N 17262483 N13084Lutz Kelly L · Auburndale, FLBuilt 1976 · S/N 17702397 N1308BHopewell Jeffrey D · Temple, TXBuilt 1955 · S/N 23-340 N13093Multiflight II Inc · Lakeville, MNBuilt 1973 · S/N 17262488 N13095Air Ally Asset Management LLC · Chisago City, MNBuilt 1973 · S/N 17262489 N13096Flights Cool LLC · La Conner, WABuilt 1973 · S/N 17262490 N13099Steeber Pauline M · Mcmurray, PABuilt 1973 · S/N 17262493 N1309U129w Holdings LLC · Terlingua, TXBuilt 1976 · S/N 17266999 N130BYCabe Robert D · San Antonio, TXBuilt 1999 · S/N 2 N130BZEvans Robert G · Choctaw, OKBuilt 2002 · S/N 21316 N130CFFlying C Leasing Ltd · Wilmington, DEBuilt 1977 · S/N 15279509 N130EOshinuga Anthony A · Valley Center, CABuilt 1940 · S/N 1029 N130ERSale Reported · Freeburg, PASale reportedS/N 1511 N130GWBruckner Peter J · Rochester, NHBuilt 1975 · S/N AA50707 N130GYRobinson Stewart · San Jacinto, CABuilt 1993 · S/N 2239 N130KWClemente Daniel L · Manheim, PABuilt 2014 · S/N 90301 N130RNPrewitt Blake S · Prescott, AZS/N 20275 N130RRAllbritten Jeffrey P · Winder, GAS/N 2841264 N130SRLimitless Aviation And Adventures LLC · Tomball, TXBuilt 1994 · S/N 1642 N130THDelage Jeffrey R · Biddeford, MEBuilt 1977 · S/N AA5A0398 N130WLBlake Larry Q · Cleveland, GABuilt 1986 · S/N 130 N130ZKrueger Mark A · Anchorage, AKBuilt 2001 · S/N 01 N13100Ruttenberg Barbara A · Lexington, KYBuilt 1973 · S/N 17262494 N13101North Hollywood Optimist Club Youth · Van Nuys, CABuilt 1973 · S/N 17262495 N13104Erley Robert B · Kirkland, WABuilt 1973 · S/N 17262498 N13108Registered aircraftBuilt 1976 · S/N 17702398 N13109Illinois Valley Flying Club · Peru, ILBuilt 1973 · S/N 17262503 N1310KVector Aviation LLC · Mentor, OHBuilt 1976 · S/N 28-7790216 N13115Kkmjj LLC · South Lyon, MIBuilt 1973 · S/N 17262507 N13117Mccullough James R · Newville, PABuilt 1973 · S/N 17262509 N13119Boomer Aviation LLC · Catoosa, OKBuilt 1973 · S/N 17262511 N13127Fisher Global LLC · Conway, ARBuilt 1973 · S/N 17262517 N13128Huffman David L · Corsicana, TXBuilt 1976 · S/N 17702400 N13129Giartlau Aviation Corp · Minneola, FLBuilt 1973 · S/N 17262519 N1312ABowen Haldor S · Sandpoint, IDBuilt 1951 · S/N 18-1114 N1312EBuswell Aviation Inc · Salem, ORBuilt 1978 · S/N 17270950 N1312USimplifly LLC · Mesa, AZBuilt 1976 · S/N 17267001 N1313Cochrane Timothy A · Chippewa Lake, OHS/N 1809013 N13131Premier Capital Enterprises LLC · Hurricane, UTBuilt 1958 · S/N TD-42 N13140Trailwinds Flying Club · Savannah, MOBuilt 1973 · S/N 17262523 N13143Riffel Victor · Benton, KSBuilt 1973 · S/N 17262526 N13144Barnstormers Club LLC · Cape Coral, FLBuilt 1973 · S/N 17262527 N13147Terra Piniun LLC · Chickaloon, AKBuilt 1973 · S/N 17262529 N1314KSimko Anthony James · Fairbanks, AKBuilt 2023 · S/N 016 N13152Quirrion Linton A · Jay, MEBuilt 1973 · S/N 17262531 N13154Howell James W · Boise, IDBuilt 1973 · S/N 17262533

Back to AD 80-04-03 R2