Registered aircraft · 111

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:92-16-12-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:92-16-12-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:92-16-12-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:92-16-12-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:92-16-12-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:92-16-12-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.

N109BGAviation Leasing Group Inc · Wilmington, DEBuilt 1982 · S/N NA0310 N10TNPacific Rim Management LLC · Downey, CAS/N 257085 N112EDE D Santos & Associates LLC Trustee · Wilmington, DES/N 258048 N117HHZephyr Air LLC · Houston, TXBuilt 1993 · S/N 258249 N117JTColcot Aviation LLC · New York, NYBuilt 1992 · S/N 258205 N118CDFirst Aviation Service Corp · Wilmington, DEBuilt 1977 · S/N NA0212 N122LJBas Part Sales LLC · Greeley, COBuilt 1993 · S/N 258239 N123HKTavaero Jet Charter Corp · Houston, TXBuilt 1992 · S/N 258208 N125SBBay Venture Management LLC · Atlanta, GABuilt 1985 · S/N 258046 N12SYMcwalsh LLC · Dover, DEBuilt 1987 · S/N 258103 N141AELake Superior College · Duluth, MNBuilt 1981 · S/N NA0306 N150SBRegistration Pending · Anchorage, AKRegistration pendingBuilt 1991 · S/N 258197 N171MDN171md LLC · Amarillo, TXBuilt 1993 · S/N 258251 N176TLBank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 258176 N180NEJunction Medical Office P C · Jackson Heights, NYS/N NA0401 N18CCTamcar Aviation LLC · Kennewick, WAS/N NA0222 N191PJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1990 · S/N 258203 N2033Aircraft Holding Solutions LLC Trustee · Newark, DES/N 258093 N212XXLegacy Aviation Trust Holdings Corp · Edmond, OKS/N 257093 N213RGGlobal Avionics LLC · Downey, CABuilt 1986 · S/N 258073 N218PJSoany Steam Inc · Cheyenne, WYBuilt 1988 · S/N NA0426 N230TSDodson International Parts Inc · Rantoul, KSBuilt 1968 · S/N NA700 N23CJGrzechowiak Gary L · Denison, TXS/N 25152 N244FLAviation Leasing Group Inc · Wilmington, DES/N 258066 N250MBNo Layover LLC · Hays, KSBuilt 1993 · S/N 258237 N257PLTavaero Jet Charter Corp · Houston, TXBuilt 1990 · S/N 258167 N26MEJ Jets Inc · Los Angeles, CABuilt 1982 · S/N NA 0315 N2787Valiair Lc Trustee · Casper, WYBuilt 1984 · S/N 257208 N285RAAsesu Aircraft LLC · Miami, FLS/N 258221 N28ZFCore Projects Inc · Fresno, CAS/N NA0458 N31ZZE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N NA0437 N323AAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N 258155 N32PJRegistered aircraftN-number assigned (import), not yet registeredS/N NA0455 N338SWN338sw LLC · Midland, TXBuilt 1992 · S/N 258229 N355FAE D Santos & & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N 258156 N369UBAlliance Air Parts Acquisitions Corp · Oklahoma City, OKS/N 258232 N412DAVida Trade And Management Group LLC · Charlotte, NCS/N 258061 N413HSAerotrust Services Corp Trustee · Wilmington, DES/N NA0413 N414PEAerotrust Services Corp Trustee · Wilmington, DES/N 258090 N418CASkybus Inc · North Miami Beach, FLBuilt 1992 · S/N 258218 N422CSBusiness Jet Managers Inc · Canton, MIBuilt 1988 · S/N 258110 N43JRGlobal Avionics LLC · Downey, CAS/N 258173 N442MSWd Aviation Group Inc · Atlanta, GAS/N NA0460 N457JAviation Leasing Group Inc · Wilmington, DEBuilt 1987 · S/N 258085 N45GDPacific Rim Management LLC · Middletown, DEBuilt 1989 · S/N 258142 N45KGAircraft Holding Solutions LLC · Newark, DEBuilt 1980 · S/N 257189 N469RJDodson International Parts Inc · Rantoul, KSBuilt 1986 · S/N 258067 N47HWCelebration Tv America Inc · Houston, TXS/N 258023 N509DMTeam Aero LLC · Shawnee, KSS/N 258056 N518RRMidas Air Corp · Wilmington, DES/N NA0278

Back to AD 92-16-12 R1