Registered aircraft · 519

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.

N8083AAir 1st Aviation Companies Of Oklahoma Inc · Tulsa, OKBuilt 1979 · S/N 739SA N817ADTucano Air Force LLC · Crowley, TXBuilt 1991 · S/N S117/T88 N81PNFreseman Christine · Redding, CABuilt 1978 · S/N 441-0037 N820DCCbg LLC · Wilsonville, ORBuilt 1993 · S/N DC820B N825SPConquest 2 Aviation LLC · Haines City, FLBuilt 1979 · S/N 441-0127 N82AFAir 1st Aviation Companies Inc · Aiken, SCBuilt 1980 · S/N 424 S.A.N82TMMkr Air LLC · Belleair, FLS/N 441-0104 N83A441 LLC · Sioux Falls, SDBuilt 1978 · S/N 441-0050 N8400KVincent Flying Service Inc · Kaplan, LABuilt 1982 · S/N 685B N840CFPappusgrass Aviation LLC · San Antonio, TXBuilt 1980 · S/N 11624 N840KBOrion Aerial LLC · Grass Valley, CABuilt 1980 · S/N 11640 N840MD&G Aviation LLC · Denver, COBuilt 1980 · S/N 11657 N840PSChs Leasing LLC · Boca Raton, FLBuilt 1981 · S/N 11672 N840RBGreat American Jet Inc · Cincinnati, OHBuilt 1981 · S/N 11699 N840SEGreen Fairways Florida Inc · Key West, FLBuilt 1979 · S/N 11610 N8481VLt Development Group LLC · Watford City, NDBuilt 1977 · S/N 2314R N848LGPia Avcenter LLC · Peoria, ILBuilt 1980 · S/N 11641 N849JSDel Mar College · Corpus Christi, TXBuilt 1988 · S/N 812 N860MABab Leasing LLC · Summerfield, NCBuilt 1977 · S/N 700SA N866DAir 1st Aviation Companies Inc · Aiken, SCBuilt 1974 · S/N 656 N878JLConquest 878 LLC · Indianapolis, INBuilt 1982 · S/N 441-0293 N87WSKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1977 · S/N 441-0009 N87XCSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 441-0133 N880ACN880ac LLC · Hastings, MIBuilt 1982 · S/N 1559SA N880GGarlynson Airways LLC · Lincoln, NEBuilt 1980 · S/N 95033 N88692Conquest Aircraft Leasing LLC · Carlsbad, CABuilt 1982 · S/N 441-0290 N887SDTesoro Capital LLC · High Point, NCBuilt 1984 · S/N 96207 N888SEAir 1st Inc · Aiken, SCBuilt 1982 · S/N 1549 S.A.N888WWVictory Aviation LLC · West Palm Beach, FLBuilt 1980 · S/N 791 S.A.N88GWWav Series LLC · Batavia, ILBuilt 1980 · S/N 441-0187 N88QTOrthoairways LLC · Westlake, TXBuilt 1981 · S/N 441-0228 N892SCDrs Sandra M Krokos And Thomas P Kislan Pc · Drums, PABuilt 1979 · S/N 392 S.A.N892WATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1976 · S/N 11273 N893KBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 415SA N8970NAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 441-0092 N89DRN89dr LLC · Lowell, ARBuilt 1978 · S/N 713SA N89SCKcb Air LLC · Pendleton, INBuilt 1981 · S/N 1516 S.A.N901MCMs Merlin LLC · Dallas, TXS/N T369 N901TECheviot Holdings LLC · Key Largo, FLBuilt 1983 · S/N 15031 N905AAGraber Joel C · Collins, MSS/N TK65 N907VMVmo LLC · Anchorage, AKS/N 1569SA N9089VWorld Class Aviation Inc · Peachtree City, GABuilt 1994 · S/N DC862M N909FSMj Aviation Inc · Walnut Ridge, ARBuilt 1995 · S/N G6-123 N910NFAir 1st Aviation Companies Of Oklahoma Inc · Tulsa, OKBuilt 1973 · S/N 623 N911KCCounty Of Kern · Bakersfield, CABuilt 1975 · S/N 11300 N913NL2242 Enterprises LLC · Dover, DES/N 15008 N916SJConquest Aviation LLC · Las Vegas, NVBuilt 1981 · S/N 441-0243 N91BFPlatinum Storage Properties LLC · Wayzata, MNBuilt 1981 · S/N 441-0245 N922HPColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1978 · S/N 441-0027 N937BBBravo Air LLC · Morristown, TNS/N 441-0248

Back to AD 86-08-06 R1