Skip to content

Registered aircraft · 40,394

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

N812BSSb3 Asset Management LLC · Gilbert, AZBuilt 2003 · S/N 97 N812CHKragenbring Brandon Jon · Lake Lillian, MNS/N 1716 N812CPHigh Wing Air Services LLC · Merritt Island, FLBuilt 1977 · S/N 17268790 N812DAHanson Aviation LLC · Winter Park, FLBuilt 1979 · S/N 17273577 N812STAk8 Assets LLC · Talkeetna, AKBuilt 1958 · S/N 22-6408 N812THSuss Charles H · Woodford, VTBuilt 1971 · S/N 17701615 N812TMJoslyn Robert A · Bristol, CTBuilt 1975 · S/N AA5-0794 N8130DEmbree Walter G · Harrisonburg, VAS/N 22-5621 N8130WAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1965 · S/N 28-2240 N8131DThompson Arthur W · Paris, TXBuilt 1957 · S/N 22-5622 N8131RPaphos Airways LLC · Farmingdale, NYBuilt 1979 · S/N 28-8016158 N8131WGaudette Philip C · Woodstock, CTS/N 28-8016159 N8131XC&W Leasing · Cedar Rapids, IAS/N 28-8016160 N81321Treacy Richard K · North Massapequa, NYBuilt 1982 · S/N 28-8216113 N81327Roman Maritza Torres · Toa Alta, PRBuilt 1980 · S/N 28-8016164 N81328Morrical Dean R · Henderson, NVBuilt 1977 · S/N AA5B0500 N8132BOptisure Risk Partners LLC · Manchester, NHBuilt 1979 · S/N 28-8090164 N8132PMiller Lawrence A · Winthrop Harbor, ILBuilt 1963 · S/N 24-3385 N8132WGore Robert E Jr · Aiken, SCBuilt 1965 · S/N 28-2243 N8133CCarter Marl · Coburg, ORBuilt 1975 · S/N 28-7690104 N8133ELane Community College · Eugene, ORBuilt 1980 · S/N 28-8016167 N8133JWarrior Aviation LLC · Stanford, KYBuilt 1979 · S/N 28-8016170 N81344November 46a Leasing Inc · St Augustine, FLBuilt 1980 · S/N 28-8016169 N81345Bailey Roger I · Silverdale, WABuilt 1977 · S/N AA5B0502 N81347Tusha Kenneth R · Yankton, SDBuilt 1977 · S/N AA5B0503 N8134DDewolf Logan J · Eagle River, AKS/N 22-4778 N8134WBrilliant Holdings LLC · Winfield, MOS/N 28-2245 N81354Figueroa Lionel · Sacramento, CAFirst renewal noticeBuilt 1977 · S/N AA5B0506 N81357Cascade Aircraft LLC · Eugene, ORBuilt 1977 · S/N AA5B0507 N81359Tuckahoe Aviation LLC · Tequesta, FLBuilt 1977 · S/N AA5B0508 N8135CCoverdale Aviation LLC · Ellendale, DEBuilt 1979 · S/N 28-8016173 N8135DDickerson Joseph Ra · Anchorage, AKBuilt 1957 · S/N 22-5626 N8135GMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-8016175 N8135PStein David J · New Port Richey, FLBuilt 1979 · S/N 28-8016176 N8135WWoodrum Alan D · Danville, ILBuilt 1965 · S/N 28-2246 N81360Ayer Edward Wayne · Warner Robins, GABuilt 1977 · S/N AA5B0509 N81364F2f LLC · Milford, CTBuilt 1977 · S/N AA5B0510 N81367Johnson David M · Baltimore, MDBuilt 1977 · S/N AA5B0512 N81368Steinruck Thomas III · Temple Terrace, FLBuilt 1977 · S/N AA5B0513 N8136JRiti Inc · Jackson, TNBuilt 1979 · S/N 28-8090173 N8136WNajjar Craig S · Norwood, MABuilt 1965 · S/N 28-2249 N81376Spackman Timothy Oliver · Houston, TXBuilt 1977 · S/N AA5B0515 N81377Mcgaughy Ellis H · Eastover, NCBuilt 1977 · S/N AA5B0516 N8137QUnited States Air Force · Hanscom Afb, MABuilt 1979 · S/N 28-8016179 N8137UMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-8016181 N81382Schear Brian · Costa Mesa, CABuilt 1977 · S/N AA5B0519 N81384Royals Navy LLC · Lewes, DEBuilt 1977 · S/N AA5B0523 N81388Byrne Jan · Greenwood, INBuilt 1977 · S/N AA5B0524 N8138DAir Group Inc · Marietta, GABuilt 1958 · S/N 22-5629 N8138EMorris John A · Phoenix, AZBuilt 1999 · S/N 146

Back to AD 79-10-03 R2