Registered aircraft · 428

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-07-05') 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-07-05') 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-07-05')
    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-07-05')
  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-07-05')
  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-07-05')
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.

N100BABemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U12 N100BRIsr Aviation LLC · Wilmington, DEBuilt 1981 · S/N LA-116 N100PYTbm Flying Lc · Pampa, TXBuilt 1981 · S/N BB-890 N102WKWillis Knighton Medical Center · Shreveport, LABuilt 1980 · S/N LA-36 N106RHSouthern Bracing Systems Inc · Armuchee, GABuilt 1978 · S/N BB-428 N108ALRj Flight LLC · Saint Petersburg, FLBuilt 1980 · S/N BB-730 N108BABemidji Aviation Services Inc · Bemidji, MNS/N U-40 N109CZN109cz LLC · Milwaukee, WIBuilt 1969 · S/N U-109 N10DHVta Capital LLC · Ontario, CABuilt 1981 · S/N LA-111 N110GGo Soar LLC · Highland Village, TXBuilt 1980 · S/N BB-792 N111AABlue Water Aviation LLC · Vestavia, ALS/N LA-6 N111CAKingmax Aviation LLC · Miami, FLBuilt 1982 · S/N LA-201 N111ENPecos Air Inc · Roswell, NMS/N LA-230 N111PVHenson Builders LLC · Dallas, TXBuilt 1981 · S/N BB-772 N114CWMatagorda Production Co · Houston, TXBuilt 1980 · S/N LA97 N117TJCoastal Community Real Estate Group LLC · Caswell Beach, NCBuilt 1980 · S/N LA17 N118MDAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-118 N11WNRds Aviation LLC · Elkhart, INBuilt 1982 · S/N LA177 N120RLIsr Platforms LLC · Mclean, VABuilt 1979 · S/N BT-9 N121LBEastern Stearman Inc Trustee · Leesburg, VAS/N BB-475 N123CHMdi Air LLC · Dothan, ALBuilt 1980 · S/N LA-32 N124KTGams Air LLC · Doral, FLBuilt 1976 · S/N BB-124 N124WRH.A.I. Services Inc · Justin, TXBuilt 1980 · S/N BB-664 N125BKColoramo Federal Credit Union · Grand Junction, COBuilt 1982 · S/N BB-977 N126JHM&P Aviation LLC · Lakeland, TNBuilt 1980 · S/N BB-595 N127GABeech Transportation Inc · Eden Prairie, MNBuilt 1977 · S/N BB312 N127TACompany Wrench Ltd · Carroll, OHBuilt 1980 · S/N BB-636 N128JPMontrachet Aviation LLC · Santa Ana, CABuilt 1979 · S/N LA-25 N128SFWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N U-87 N12NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 1979 · S/N BB-581 N130BABemidji Aviation Services Inc · Bemidji, MNBuilt 1969 · S/N U-80 N130RLOscar Charlie II LLC · California, MDBuilt 1980 · S/N BT16 N131SJGravitas Aviation LLC · Dallas, TXBuilt 1976 · S/N BB-131 N131SPKauffman Land & Development LLC · Denver, COBuilt 1983 · S/N LA-206 N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137 N139RRRyan Renae L Trustee · Wichita, KSBuilt 1976 · S/N BB-177 N140RLN140rl LLC · Kalispell, MTBuilt 1982 · S/N BT22 N143DEAac 585 LLC · Kennesaw, GABuilt 1979 · S/N BB-585 N14MVAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U59 N150CNKing Air Investments LLC · Ferriday, LABuilt 1981 · S/N LA-138 N151ELCarolina Turbine Sales Inc · Raleigh, NCBuilt 1978 · S/N BB-371 N152CTThumann Chad · Pearland, TXS/N 160471 N152TTThumann Chad · Pearland, TXS/N 162260 N152WLHeart One LLC · Little Rock, ARBuilt 1977 · S/N BB-260 N1560Davis Aviation Inc · Brandon, MSS/N BC-09 N15KALighthouse Air LLC · Hobe Sound, FLBuilt 1979 · S/N BB-457 N160SFTriumph Aviation LLC · Gaylord, MIBuilt 1975 · S/N BB-32 N164HAUas Transervices Inc · Boca Raton, FLBuilt 1968 · S/N U-60 N16WGSomers-Lawson Land & Cattle LLC · Midland, TXS/N LA-226 N170RLN170rl LLC · California, MDBuilt 1983 · S/N BT28

Back to AD 80-07-05