Registered aircraft · 106

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-07-03') 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-07-03') 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-07-03')
    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-07-03')
  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-07-03')
  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-07-03')
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 N119URegistration Pending · South Portland, MERegistration pending, canceledBuilt 1992 · S/N 259007 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 N304BHCalla Airwaysllc · Cohasset, MAS/N NA1003 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 N333RLJetstream Air LLC · Colfax, NCBuilt 1992 · S/N 259027 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 N39QJAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 1993 · S/N 259039 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 N511BKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 259031 N515LRAviation Dynamics LLC · South Portland, MEBuilt 1998 · S/N NA1006 N520LR1489 LLC · New York, NYBuilt 1992 · S/N NA1008 N520SBBank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 259032 N524LRUsac Airways 693 LLC · Fort Lauderdale, FLBuilt 1992 · S/N 259-024 N52SMWumac Inc · South Portland, MES/N NA1009 N533LRAviation Dynamics LLC · South Portland, MEBuilt 1992 · S/N 259033 N541LRBank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 259041

Back to AD 88-07-03