Registered aircraft · 85

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:88-01-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:88-01-01') 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:88-01-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:88-01-01')
  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:88-01-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:88-01-01')
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.

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 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 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 N191PJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1990 · S/N 258203 N2033Aircraft Holding Solutions LLC Trustee · Newark, DES/N 258093 N213RGGlobal Avionics LLC · Downey, CABuilt 1986 · S/N 258073 N218PJSoany Steam Inc · Cheyenne, WYBuilt 1988 · S/N NA0426 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 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 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 N58BLHawker 800xp LLC · Fort Lauderdale, FLS/N 258236 N591CFKmw Flight LLC · Wilmington, DEBuilt 1989 · S/N 258175 N606Sale Reported · La LagunitaSale reportedBuilt 1987 · S/N 258068 N609RBAviation Group Jmj Inc · Callahan, FLExpired dealer, pending cancellationBuilt 1984 · S/N 258019 N616WGForza Wings LLC · Laredo, TXBuilt 1985 · S/N 258030 N6200HTnr Aircraft Holdings LLC · Englewood, COBuilt 1987 · S/N 258087 N65DLChestnut Northern Partners LLC · Farmington Hills, MIBuilt 1993 · S/N 258224 N664SCAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1985 · S/N 258032 N671MMKmwflight LLC · Wilmington, DEBuilt 1984 · S/N 258014 N671RRAircraft Fidelity Corp Trustee · Dover, DEBuilt 1993 · S/N 258244 N682DN682d LLC · Wilmington, DES/N NA0431 N68ARTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1992 · S/N 258234

Back to AD 88-01-01