Skip to content

Registered aircraft · 20,687

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N78305Woollen Claude D · Moore, SCBuilt 1968 · S/N 17257562 N7830GSkildum&Company LLC · Grand Marais, MNBuilt 1970 · S/N 17259530 N7830TWalker Homes LLC · Stratford, OKBuilt 1960 · S/N 47430 N7830UObrien Cornelius R · Sellersville, PABuilt 1964 · S/N 17251830 N78312Roemer Joanne · Kemah, TXS/N 17257565 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 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 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 N7834TYturri David P · Marble Falls, TXBuilt 1960 · S/N 47434 N7834USirens Call LLC · Nashville, TNBuilt 1964 · S/N 17251834 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 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 N7836XOsage Aviation LLC · Yates Center, KSS/N 17248336 N78371Lillace Kevan · Shelby, MTBuilt 1968 · S/N 17257590 N78375Bozeman Leasing Inc · Bozeman, MTS/N 17257593 N7837GGlass Jay Thomas · El Dorado, ARBuilt 1970 · S/N 17259537 N7837UCommander Aviation LLC · Monroe, MIBuilt 1964 · S/N 17251837 N78385Amf Aviation LLC · Dallas, GABuilt 1968 · S/N 17257595 N78388Fortner Weston · Fort Payne, ALBuilt 1968 · S/N 17257596 N78395Fgds LLC · Louisville, KYBuilt 1968 · S/N 17257599 N7839GGerty Air LLC · Sidney, MEBuilt 1970 · S/N 17259539 N7839XBedsole Jerry L · Elba, ALBuilt 1961 · S/N 17248339 N783BGAir Shares LLC · Casper, WYBuilt 2001 · S/N 17281021 N783DGJeffery & Weiss Holdings LLC · Long Beach, CABuilt 1980 · S/N 17274063 N783EAElevation Air Capital LLC · Janesville, WIBuilt 2020 · S/N 172S12555 N783EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12913 N783EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13575 N783FMFmfa Inc · Wilmington, DEBuilt 1980 · S/N 17274259 N783SFBremfour Aviation Group Inc · Wilmington, DEBuilt 2001 · S/N 172S8980 N78408On The Fly Aero LLC · Ocean City, NJBuilt 1968 · S/N 17257604

Back to AD 90-06-03 R1