Skip to content

Registered aircraft · 357

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

N100DSCascade Peaks Aviation LLC · Springfield, ORBuilt 1990 · S/N 550-0639 N102DRCloud 9 LLC · Lafayette, LABuilt 1982 · S/N 551-0436 N102HBBuzz-Air Of Indiana Inc · Michigan City, INBuilt 1982 · S/N 550-0409 N103HCEstar Aerospace Corp · Columbus, OHS/N A068 S.A.N106SRSafari Intl LLC · Lewes, DEBuilt 1982 · S/N 550-0346 N107EEBlandco LLC · Greenville, SCBuilt 1991 · S/N 5500667 N109GAFinancial Mistake Air LLC · Uvalda, GABuilt 1980 · S/N 550-0124 N109JCL&F Aviation LLC · Dallas, TXBuilt 1979 · S/N 550-0099 N10EGJarcav LLC · The Woodlands, TXBuilt 1979 · S/N 550-0055 N10LYAir & Water Research Corp · Wilmington, DEBuilt 1983 · S/N 550-0466 N10TCGardner Aviation LLC · Hot Springs, ARBuilt 1984 · S/N 550-0495 N111AFWings Aloft Inc · Portland, ORBuilt 1981 · S/N 550-0256 N111GJMalik Hassan · Richfield, OHBuilt 1980 · S/N 5510187 N111LJSourek Trail Co Inc · Barberton, OHBuilt 1982 · S/N 550-0350 N111SGAir Orlando Helicopters And Leasing · New Smyrna Beach, FLBuilt 1980 · S/N 550-0196 N1163MNew World Aviation LLC · Edinburg, TXBuilt 1988 · S/N 550-0568 N116KCRa Aviation LLC · Dover, DEBuilt 1980 · S/N 550-0149 N1200NCoulson Aviation (USA) Inc · Portland, ORBuilt 1992 · S/N 550-0681 N121HLAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1980 · S/N 550-0121 N121KMWings By Dkw LLC · Lake Charles, LABuilt 1981 · S/N 550-0273 N121MJIal Corp · Lewes, DEBuilt 1984 · S/N 550-0489 N123TLN919cs LLC · Colts Neck, NJBuilt 1987 · S/N S550-0124 N1249PTrns Solutions LLC · Lewes, DEBuilt 1982 · S/N 550-0451 N1250VAquila Air LLC · Cincinnati, OHS/N 550-0439 N1252DAeroelite Aviation LLC · Columbia, MOBuilt 1983 · S/N 551-0476 N12549Surdex Corp · Chesterfield, MOS/N 550-0501 N1255KCypress Aircraft Sales LLC · Clermont, FLS/N 550-0505 N125RGAero South Florida Corp · West Palm Beach, FLBuilt 1981 · S/N 550-0248 N127CLWyoming Aviation LLC · Sheridan, WYBuilt 1978 · S/N 550-0007 N127JMN127jm LLC · Clovis, NMBuilt 1981 · S/N 550-0253 N12JEProfessional Pilot Training Inc · Eagle Lake, TXBuilt 1980 · S/N 550-0185 N14RM29foxtrot LLC · Wilmington, DEBuilt 1980 · S/N 551-0169 N153TN153t LLC · Kalispell, MTS/N 550-0732 N163JN163j LLC · Smithfield, NCBuilt 1987 · S/N S550-0122 N168ESNext Generation Aviation LLC · Beloit, WIBuilt 1992 · S/N 550-0706 N16PLSolitaire Development LLC · Temecula, CABuilt 1981 · S/N 550-0265 N16RPRose Aviation LLC · Sarasota, FLBuilt 1985 · S/N S5500047 N16TSCypress Aircraft Sales LLC · Clemont, FLS/N 550-0030 N173AAInterstate Health Solutions LLC · Orlando, FLBuilt 1980 · S/N 550-0234 N174DRIal Corp · Lewes, DEBuilt 1979 · S/N 550-0074 N177RJL&S Enterprises LLC · Daytona Beach, FLS/N 550-0550 N181EBSportsmed Aviation LLC · Gulf Breeze, FLBuilt 1982 · S/N 550-0369 N181GMid South Agricultural Products Inc · Lafayette, LAS/N S550-0006 N18HJFanac LLC · Palestine, TXBuilt 1988 · S/N 550-0587 N191TFCci Air LLC · Gary, INBuilt 1988 · S/N 550-0567 N197PRGoodnights Spruce Goose LLC · Harmony, NCBuilt 1992 · S/N 550-0704 N1SVJtl Leasing Co LLC · Kalispell, MTBuilt 1980 · S/N 550-0150 N200NCMidwest Jet LLC · Lynd, MNBuilt 1980 · S/N 550-0184 N204CFCorporate Flight Inc · Waterford, MIBuilt 1980 · S/N 550-0238 N204PMDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 550-0320

Back to AD 78-17-06