Registered aircraft · 520

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:86-08-06-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:86-08-06-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:86-08-06-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:86-08-06-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:86-08-06-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:86-08-06-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.

N100BYFirst Flight Aviation LLC · Boerne, TXBuilt 1984 · S/N 1565 S.A.N100MUWakaya Services Inc · Dover, DEBuilt 1980 · S/N 793SA N100TWTexas La Flyers LLC · Monroe, LABuilt 1978 · S/N BE-51 N101MCMarc Inc · Bolton, MSBuilt 1973 · S/N T234 N101WAP M Leasing Inc · Perris, CABuilt 1969 · S/N SH1859 N107BHBighorn Airways Inc · Sheridan, WYBuilt 1979 · S/N 165 N108EBAndrie Inc · Muskegon, MIBuilt 1980 · S/N BE-108 N109BHBighorn Airways Inc · Sheridan, WYBuilt 1981 · S/N 192 N112BHBighorn Airways Inc · Sheridan, WYS/N 292 N112CZDelta Delta Papa LLC · Fort Lauderdale, FLBuilt 1981 · S/N 441-0233 N114LHAirborne Support Group LLC · Marion, MTBuilt 1974 · S/N SH-1926 N1158Alaskan Air Charter LLC · Anchorage, AKS/N SH1951 N1164FRegistration Pending · Dickerson, MDRegistration pendingS/N 1562 S.A.N11SJSouthland Metroplex Aviation LLC · Colleyville, TXBuilt 1973 · S/N 285 N120TMInterstate Automotive Services Inc · Franklin, TNBuilt 1981 · S/N T-405 N1212CDodson International Parts Inc · Rantoul, KSBuilt 1985 · S/N 441-0346 N121JWGlobal Jet LLC · Missoula, MTBuilt 1975 · S/N 11299 N122CKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 374SA N124PAJ31 Partners LLC · Nashville, TNBuilt 1984 · S/N 643 N124PCSaxton Leasing Inc · Plymouth, MIS/N 438SA N125MMFox Tango Tango Inc · Houston, TXBuilt 1979 · S/N 11605 N128EZN128ez LLC · Anchorage, AKBuilt 1979 · S/N 441-0128 N12MFMontana Aircraft Trust Inc Trustee · Bozeman, MTS/N T-417 N12VAAirborne Research LLC · Fort Pierce, FLS/N 96062 N13YSAir 1st Aviation Companies Inc · Aiken, SCBuilt 1976 · S/N 694 N143JACosco & Associates Inc · Crestview, FLBuilt 1974 · S/N 324 N144PLCatskill Transportation LLC · Kingston, NYBuilt 1984 · S/N 42-5527014 N145FSSolitaire LLC · Appleton, WIS/N 437 S.A N14NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1980 · S/N 4410171 N14TA35th Terrace LLC · Wellington, FLBuilt 1980 · S/N 441-0168 N150BAKenai River Xpress LLC · Soldotna, AKBuilt 1953 · S/N 15 N158MCBemidji Aviation Services Inc · Bemidji, MNBuilt 1988 · S/N AC-726B N159MCGas/Wilson Inc · Traverse City, MIS/N AC-728B N15DBN15db LLC · Bend, ORBuilt 1981 · S/N 441-0278 N15TRNorthwest Aviation LLC · Fargo, NDBuilt 1981 · S/N 446 S.A.N162ALNeptune Aviation Services Inc · Missoula, MTBuilt 1975 · S/N 11231 N165MARegistered aircraftBuilt 1975 · S/N 326 N167RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1978 · S/N 11437 N169CAArizona State University · Hilo, HIBuilt 1986 · S/N 8088 N169MFCommodore Aviation LLC · Palm Beach, FLBuilt 1981 · S/N 441-0221 N16NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N 441-0045 N170PCAircraft Propulsion Leasing LLC · Holland, OHBuilt 1986 · S/N 717 N171ATAloft Aviation Services LLC · Spartanburg, SCBuilt 1966 · S/N 1616-49 N175CAAir 1st Aviation Companies Of Oklahoma Inc · Tulsa, OKBuilt 1979 · S/N 736SA N175RCCbp Air Logistics LLC · Statham, GABuilt 1976 · S/N BE-3 N175SWDenaina Air Taxi LLC · Anchorage, AKBuilt 1985 · S/N AC 621-B N178SBCrawford Setrige · Santa Barbara, CAS/N 435 S.A.N17HGMu2 LLC · Lewes, DEBuilt 1981 · S/N 1510 S.A.N17VVPro Field Services Inc · Hallettsville, TXBuilt 1985 · S/N TT536 N184SWCbg LLC · Wilsonville, ORBuilt 1986 · S/N AC-647

Back to AD 86-08-06 R1