Skip to content

Registered aircraft · 25,369

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N66090Skyline Solutions Inc · Deland, FLBuilt 1983 · S/N 17275963 N6609DCopperhead Environmental Consulting Inc · Paint Lick, KYBuilt 1979 · S/N 17272896 N6609WKingsford Smith LLC · Tulsa, OKBuilt 1982 · S/N P21000804 N660BCHolland Jack R · Mc Lean, ILBuilt 2017 · S/N 583-2017 N660CMJj Aviation LLC · Saint Peters, MOBuilt 2006 · S/N 1028-2006 N660SRAom Aircraft LLC · Orlando, FLBuilt 1968 · S/N 17701151 N660TAReinhardt Anthony C · Duchesne, UTBuilt 1970 · S/N 17259612 N660TMPeacock Quarry L · Post Falls, IDBuilt 2000 · S/N 407-99 N6611DMoralli Joseph · Chico, CABuilt 1979 · S/N 17272898 N6612RCourtney David P · Reedsport, ORBuilt 1979 · S/N 172RG0214 N6612VEverman Terry Jay · Vassar, MIBuilt 1980 · S/N 172RG0781 N6613H6613 H Ltd · Wilmington, DEBuilt 1975 · S/N 17265510 N6614VThomas Anna D · Kiana, AKS/N 172RG0782 N6614YBoots LLC · Clay Center, KSS/N 21064460 N6615DCivil Air Patrol Inc · Montgomery, ALBuilt 1979 · S/N 17272902 N6615NTexas Skyways Research & Development · Boerne, TXBuilt 1981 · S/N 18267845 N66168C P Aviation · Santa Paula, CABuilt 1983 · S/N 17275974 N6616DMjng Investment Group LLC · Melbourne, FLBuilt 1979 · S/N 17272903 N6616HBurke Anthony · Poughkeepsie, NYBuilt 1975 · S/N 17265511 N66174Pea-Wayman Flight LLC · Daytona Beach, FLS/N 17275975 N6617CN6617c Inc · Calumet City, ILBuilt 1980 · S/N 21063933 N6617ELinstad Daniel Elmer · Canby, ORBuilt 1978 · S/N 17272045 N6617HNorth Franklin County Flying Club · North Lawrence, NYBuilt 1975 · S/N 17265512 N6617JJeffries Holdings LLC · Bargersville, INBuilt 1980 · S/N 17273900 N66189Skynick Enterprises Inc · Tarzana, CABuilt 1983 · S/N 17275976 N6618DStein Air LLC · New Ringgold, PABuilt 1979 · S/N 17272905 N6618VLang Gerald K · Baker, MTBuilt 1980 · S/N 172RG0783 N6619DBannwart Justin S · North Liberty, INBuilt 1979 · S/N 17272906 N6619ULucas Jolie Candace · Pismo Beach, CABuilt 1965 · S/N 732 N661CPSouthern Aircraft Consultnacy Inc Trustee · Casper, WYBuilt 1969 · S/N 661 N661KFurrow Terry · Hinton, OKBuilt 1978 · S/N 177RG1311 N6620CDieck Steven L · Lake Villa, ILBuilt 1966 · S/N 3327 N6620DPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 17272907 N6620RWhite Richard C · Tracy, CABuilt 1979 · S/N 172RG0217 N6620VHall Steven R · Cambridge, MABuilt 1980 · S/N 172RG0784 N66213Global Adventures N66213 LLC · Hollywood, FLBuilt 1983 · S/N 17275980 N66215Channel Islands Aviation Inc · Camarillo, CABuilt 1983 · S/N 17275982 N6621AJc Investors Group LLC · Coral Springs, FLBuilt 1979 · S/N 21063559 N6621DCosta Air Service LLC · Painted Post, NYBuilt 1979 · S/N 17272908 N6622CMidnight Flight LLC · Wells, TXBuilt 1980 · S/N 21063936 N6622DArq Aviation LLC · Wilmington, NCBuilt 1979 · S/N 17272909 N6622YSierrakilo LLC Trustee · Lewes, DES/N 21064464 N66230East Hill Flying Club Inc · Ithaca, NYBuilt 1983 · S/N 17275985 N6623GMehling Robert C · Hardin, MTS/N 18801208 N6623ZMage Aircraft Leasing LLC · San Antonio, TXBuilt 1980 · S/N 172RG0240 N6624GBob Hoover Academy · Salinas, CABuilt 1979 · S/N 17273611 N6624HSakata Lissa C · Falls Church, VAS/N 17265515 N6625NRogers Charles W Trustee · Newbury Park, CABuilt 1978 · S/N 21063126 N662VN662v LLC · Starkville, MSS/N 357-73 N6634PAviation-Avsec Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1978 · S/N P21000194

Back to AD 80-25-07 R1