Skip to content

Registered aircraft · 25,367

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.

N130LAInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 21-1175 N130RCWilliams Brian G · Las Cruces, NMBuilt 1983 · S/N P21000822 N130VUSwords Kyle · New Albany, MSBuilt 1975 · S/N 180-75 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 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 N1312EBuswell Aviation Inc · Salem, ORBuilt 1978 · S/N 17270950 N1312USimplifly LLC · Mesa, AZBuilt 1976 · S/N 17267001 N1312WKing Scott W · Tampa, FLBuilt 1963 · S/N 200 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 N1314UKilgore Don H · Jasper, ALBuilt 1982 · S/N 21064685 N1314WNeches Air Inc · Silsbee, TXBuilt 1963 · S/N 202 N13152Quirrion Linton A · Jay, MEBuilt 1973 · S/N 17262531 N13154Howell James W · Boise, IDBuilt 1973 · S/N 17262533 N13156Mph Aviation LLC · Eastanollee, GABuilt 1973 · S/N 17262535 N13157Red River Flyers Inc · Wahpeton, NDBuilt 1973 · S/N 17262536 N1315ETada Aero LLC · Worthington, OHBuilt 1978 · S/N 17270951 N1315UMcgonagill Billy D · Mount Pleasant, TXBuilt 1976 · S/N 17267004 N13160Dey James M · Waterford, MIBuilt 1973 · S/N 17262538 N13164Jameson Kelly J · Chappell Hill, TXBuilt 1973 · S/N 17262542 N131691521 LLC · Antigo, WIBuilt 1973 · S/N 17262546 N1316WKurek Daniel L · Garden City, UTBuilt 1963 · S/N 204 N13171Tagle Robert J · San Antonio, TXBuilt 1973 · S/N 17262548 N13178Tappan Jay M · St Helens, ORBuilt 1973 · S/N 17262549 N1317EAbove And Beyond Aviation LLC · Austin, TXBuilt 1978 · S/N 17270952 N1317ULondondeery Flying Club Inc · Litchfield, NHBuilt 1976 · S/N 17267006 N1317WMorgenfeld Thomas A · Camarillo, CABuilt 1963 · S/N 205 N13180Skyward Fleet Solutions LLC · Granite Bay, CABuilt 1976 · S/N 17702402 N13182Spillman Aviation LLC · Colorado Springs, COBuilt 1973 · S/N 17262552 N13185Good Flight LLC · Colchester, CTBuilt 1973 · S/N 17262554 N13187Fly Aviation Corp · Wilmington, DES/N 17262556 N13190Donham Rita M · Cora, WYBuilt 1973 · S/N 17262559 N13196Frederick Christopher N · North Mankato, MNBuilt 1973 · S/N 17262563 N1319UMarsh John E · Washington, DCS/N 17267008 N131CFBurke Christopher L · Gordon, GABuilt 1978 · S/N 15282248 N131DWWeitz David M · Caldwell, IDBuilt 2015 · S/N 569-2015 N131FROptic Air LLC · Sioux Center, IAS/N 17276252 N131GSStanley Gerald L · Littleton, COBuilt 1999 · S/N 839-99 N131JDMccurry Patty Trustee · Ocala, FLBuilt 1978 · S/N 17270668

Back to AD 80-25-07 R1