Skip to content

Registered aircraft · 54,015

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N78303Citizen Air LLC · Port Angeles, WABuilt 1968 · S/N 17257560 N78305Woollen Claude D · Moore, SCBuilt 1968 · S/N 17257562 N7830GSkildum&Company LLC · Grand Marais, MNBuilt 1970 · S/N 17259530 N7830KColberg Sigurd E · Palmer, AKBuilt 1976 · S/N 18052764 N7830TWalker Homes LLC · Stratford, OKBuilt 1960 · S/N 47430 N7830UObrien Cornelius R · Sellersville, PABuilt 1964 · S/N 17251830 N7830ZFlanary Kenneth Mitchell · Five Points, ALBuilt 1963 · S/N 15059930 N78312Roemer Joanne · Kemah, TXS/N 17257565 N7831FHallmark Ryan M · Vidor, TXBuilt 1966 · S/N 15063931 N7831UHerrin Thomas · Patterson, GABuilt 1964 · S/N 17251831 N7831XChupka Kris W · Golden, COBuilt 1961 · S/N 17248331 N7832TN7832t LLC · Wilmington, DEBuilt 1960 · S/N 47432 N7832UFly 32u LLC · Monroe, NCBuilt 1964 · S/N 17251832 N7832ZArnold Mark D · Holloway, MNS/N 15059932 N78330Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257567 N78331Clifton Jack D · La Junta, COS/N 17257568 N78332Albright John T · Decatur, ALBuilt 1968 · S/N 17257569 N78335Marotte David J · Windham, NHBuilt 1968 · S/N 17257570 N78338Mbh Aviation LLC · Tulalip, WABuilt 1968 · S/N 17257572 N78339Hopfmann Alwin E · Rutland, MABuilt 1968 · S/N 17257573 N7833GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259533 N7833MFoote Lori A · Decherd, TNBuilt 1960 · S/N 17247978 N7833TJohnson Spring M · Wortham, TXBuilt 1960 · S/N 47433 N7833ULfs Inc · Gillette, WYBuilt 1964 · S/N 17251833 N78340Mcclellen Andrew C · Dallas, TXBuilt 1973 · S/N 18261760 N78341Davis Glenn A · Fair Oaks, CABuilt 1968 · S/N 17257575 N78349Raker Theodore B · Hahira, GABuilt 1968 · S/N 17257578 N7834GSmith Perry L · Brook Park, MNS/N 17259534 N7834KSautner Steve · Anchorage, AKBuilt 1976 · S/N 18052768 N7834TYturri David P · Marble Falls, TXBuilt 1960 · S/N 47434 N7834USirens Call LLC · Nashville, TNBuilt 1964 · S/N 17251834 N7834ZRall Jared W · Williamsport, PABuilt 1963 · S/N 15059934 N78351Caron John · Ellsworth, MIBuilt 1968 · S/N 17257579 N78354Tonar Richard J Jr · Omaha, NES/N 17257581 N78355Fleming Gary R · Wickliffe, KYBuilt 1968 · S/N 17257582 N78358All American Aviation LLC · Fort Worth, TXS/N 17257585 N78359Burns Stanley R · Flagler, COBuilt 1968 · S/N 17257586 N7835MTimpauer Alberto N · Mesa, AZS/N 33476 N7835TRound Engine Aero · Nashville, MIBuilt 1960 · S/N 47435 N7835UEyrie Aviation LLC · Suwanee, GAFirst renewal noticeBuilt 1964 · S/N 17251835 N78367Dardis Barry J · Great Falls, MTBuilt 1968 · S/N 17257587 N7836KKennedy Brent Robert · Anchorage, AKBuilt 1952 · S/N 20631 N7836XOsage Aviation LLC · Yates Center, KSS/N 17248336 N7836ZSpartan National Holdings LLC · Missoula, MTBuilt 1963 · S/N 15059936 N78371Lillace Kevan · Shelby, MTBuilt 1968 · S/N 17257590 N78375Bozeman Leasing Inc · Bozeman, MTS/N 17257593 N7837FObrien Daniel N Jr · Bellevue, WABuilt 1973 · S/N A1500450 N7837GGlass Jay Thomas · El Dorado, ARBuilt 1970 · S/N 17259537 N7837UCommander Aviation LLC · Monroe, MIBuilt 1964 · S/N 17251837 N7837ZBouvier Louis M III · Monticello, UTFirst renewal noticeBuilt 1963 · S/N 15059937

Back to AD 87-20-03 R2