Skip to content

Registered aircraft · 25,370

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.

N485TMitchell Lisa Marie · Lake Villa, ILBuilt 2004 · S/N 973-2004 N4860BWeaver Dianna K · Benton, LABuilt 1979 · S/N 15283678 N48610Redstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1977 · S/N 15280922 N4861GFlying Colors Airparts Inc · Leesburg, FLBuilt 1979 · S/N 17273408 N4861SMidwest Airmotive Inc · Mount Sterling, KYBuilt 1979 · S/N R18201439 N4861VRegistered aircraftBuilt 1980 · S/N 172RG0403 N48637K S Aviation · Atwater, CABuilt 1977 · S/N 15280924 N4863QKlamar Spraying Inc · Gatzke, MNBuilt 1976 · S/N 18802599T N4863TM & M Light Transportation Co Inc · Duluth, MNBuilt 1981 · S/N R18201778 N4864DChiota Aviation LLC · Waco, TXFirst renewal noticeBuilt 1979 · S/N 17272377 N4864GLazy Eights Holdings LLC · Greenwood, INBuilt 1979 · S/N 17273411 N4864YWilliams R E · Fort Walton Beach, FLBuilt 1980 · S/N 21064021 N48650Herion Chris W · Williamsburg, VABuilt 1977 · S/N 15280926 N4865DBlack Hound Aviation LLC · Austin, TXS/N 17273904 N4865PThundersky Farms Inc · Helena, MTBuilt 1978 · S/N P21000124 N4867DFlynn Brian · Auburndale, FLBuilt 1979 · S/N 17272378 N4867KMark Thomas Productions LLC · Ketchum, IDBuilt 1979 · S/N P21000349 N4868EVero Technical Support Inc · Pensacola, FLBuilt 1978 · S/N 17271671 N48690Chamberlin William C · Williamsburg, MIBuilt 1977 · S/N 15280929 N4869LCentral Texas College · Killeen, TXBuilt 1980 · S/N 15284237 N486MSInternational Air Services Inc Trustee · Carson City, NVS/N 172RG0369 N48708Greene Caleb M · Laverne, CAS/N 15280934 N4870DSherman Hess M · Poplar Grove, ILBuilt 1979 · S/N 17272379 N4870GCal Aggie Flying Farmers Inc · Davis, CABuilt 1979 · S/N 17273417 N4870PWooten Gerry W · Edmond, OKBuilt 1980 · S/N 15284834 N48710Conner Michael James · Scotts Valley, CABuilt 1977 · S/N 15280935 N4871RWagner James M · Le Sueur, MNBuilt 1978 · S/N R18200615 N4871TApex Corporation · Stanley, NDS/N R18201779 N4871VBt Aero Precission Flight Accademy LLC · Oakdale, CABuilt 1980 · S/N 172RG0406 N48725Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280937 N4872DPs N4872d LLC · Green Bay, WIBuilt 1979 · S/N 17272381 N4872HPassanante John L · Newtown, PABuilt 1981 · S/N 18267849 N4872KMike Papa LLC · Newton, KSBuilt 1979 · S/N P21000351 N4873G4873g Flying Club Inc · Punxsutawney, PABuilt 1979 · S/N 17273420 N4873RCavu Clearing LLC · Center Harbor, NHBuilt 1978 · S/N R18200616 N4873SBurke Mark S · Kindred, NDBuilt 1979 · S/N R18201440 N4874BKoppelmann Kevin J · Cuba, MOS/N 15283687 N48751Tyau Jon S · Las Vegas, NVBuilt 1977 · S/N 15280951 N48753Harford Flying Club Inc · Kingsville, MDBuilt 1977 · S/N 15280952 N48757Stone To Glass LLC · Lake Worth, FLBuilt 1977 · S/N 15280956 N4875DNightwing Productions LLC · Aptos, CABuilt 1967 · S/N 670218 N4875KHolland Karey Lynn · North Plains, ORBuilt 1979 · S/N P21000353 N48762Carter Flygare Inc · Sacramento, CABuilt 1979 · S/N 15283369 N48763Jet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15280959 N48764Cohen Harold L · Pensacola, FLBuilt 1979 · S/N 15283370 N48768General Aviation Support Corp · Rosamond, CAS/N 15283371 N4876FCosta Air Service LLC · Painted Post, NYBuilt 1979 · S/N 17273094 N4876GKing Bryan A · Austin, TXBuilt 1979 · S/N 17273423 N4876YCarson Engineering And Manufacturing Inc · Springdale, ARBuilt 1980 · S/N 21064025 N48779Bryan Robert G · Orland Park, ILBuilt 1977 · S/N 15280963

Back to AD 80-25-07 R1