Skip to content

AD 2000-25-02 R1

Registered aircraft · 7,563

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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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.

N85222Dm Asset Management LLC · Plain City, OHS/N 7AC-3955 N85223Gautreau Peter F · Chickaloon, AKBuilt 1946 · S/N 7AC-3956 N85225Bushby Harvey M · Minooka, ILBuilt 1946 · S/N 7AC-3958 N85226Hosmer Richard S · Baileyton, ALBuilt 1946 · S/N 7AC-3960 N85227Seesholtz Bros Inc · Bloomsburg, PABuilt 1946 · S/N 7AC-3961 N85229Fowler Bradley · Madisonville, KYBuilt 1946 · S/N 7AC-3963 N8522EHall Robert P · Decatur, ALBuilt 1959 · S/N 7GC-82 N85234Decker Kenneth W · Ottawa, OHBuilt 1946 · S/N 7AC-3968 N85244Liljenberg Gary W · Broolyn, OHBuilt 1946 · S/N 7AC-3978 N85247Free Richard D · Clearwater, KSBuilt 1946 · S/N 7AC-3981 N85248Rishovd Thomas A II · Elk River, MNBuilt 1946 · S/N 7AC-3982 N85251Baeder Ryan M · West Bloomfield, MIBuilt 1946 · S/N 7AC-3985 N85252Murphy Marcus P · Williamson, GABuilt 1946 · S/N 7AC-3986 N85253Covey Keith L · San Angelo, TXBuilt 1946 · S/N 7DC-3987 N85254Orback Michael J · Loveland, COBuilt 1946 · S/N 7AC-3988 N85255Berkley William H Jr · Montgomery, TXBuilt 1946 · S/N 7AC-3989 N85257Musolf Jr William R · Spencer, OHBuilt 1946 · S/N 7AC-3991 N85259Jeffryes Richard B · Creswell, ORBuilt 1946 · S/N 7AC-3993 N8525ECal-Aerofab Flight Academy Inc · Chino, CABuilt 1959 · S/N 7FC-332 N8526Core Tech Services & Supply LLC · Odessa, FLBuilt 1973 · S/N 449-73 N85262Winchell Larry · Salem, NJBuilt 1946 · S/N 7AC-3997 N85265Southard Ron L · Lincoln, DEBuilt 1946 · S/N 7AC-4000 N85276Wildy David D · Manila, ARBuilt 1946 · S/N 7AC-4011 N85277Perry Jack S · New Auburn, WIBuilt 1946 · S/N 7AC-4015 N85278Dendy Dwight E · Caledonia, ILBuilt 1946 · S/N 7AC-4016 N85279Larue Mark C · Leander, TXBuilt 1946 · S/N 7AC-4017 N8528Somerville Billy J · Newport, NCBuilt 1973 · S/N 68-73 N85281Weinhandl Lee A · Mandan, NDBuilt 1946 · S/N 7AC-4019 N85283Smith Michael D · Brookland, ARBuilt 1946 · S/N 7AC-4021 N85284Nebraska Antique Airplane Preservation Inc · Wynot, NEBuilt 1946 · S/N 7AC-4022 N85286Houndy Aviation LLC · Suffolk, VABuilt 1946 · S/N 7AC4024 N85288Vincent Raymond A · Plymouth, MIBuilt 1946 · S/N 7AC-4026 N85290Mcgee Stacy Marie · Portola, CABuilt 1946 · S/N 7AC-4028 N85291Phelps Lawrence D · Vinton, IABuilt 1946 · S/N 7AC-4029 N85292Short David J · Warrensburg, MOS/N 7AC-4030 N85293Willis Nelson W · Lebanon, TNBuilt 1946 · S/N 7AC-4031 N85294Burch Daniel C · Osceola, WIBuilt 1946 · S/N 7AC4032 N85301Desjarlais Kaleb · Anchorage, AKBuilt 1946 · S/N 7AC-4039 N85302Green Dwayne C · Santa Rosa, CABuilt 1946 · S/N 7AC-4040 N85308Travland Lewis H · Alpine, TXBuilt 1946 · S/N 7AC-4046 N85311Mccartney James P · Lake Tapps, WABuilt 1946 · S/N 7AC4050 N85312Townsley Michael F · Deep River, IABuilt 1946 · S/N 7AC-4051 N85313Howell Nicholas A · Englewood, COBuilt 1946 · S/N 7AC-4052 N85314Parobek Edward G · Cincinnati, OHBuilt 1946 · S/N 7AC-4053 N85317Adamko Victor W · Riley, MIBuilt 1946 · S/N 7AC-4056 N8531EWarzecha Allan A · Holdingford, MNBuilt 1959 · S/N 7FC-337 N85329Bahmann Frank · Dade City, FLBuilt 1946 · S/N 7AC-4068 N8532EBucciarelli Dominick F · Pueblo, COBuilt 1959 · S/N 7FC-338 N85331King William A · North Java, NYBuilt 1946 · S/N 7AC-4070 N85335Zimmerman Arnold A · Ava, MOBuilt 1946 · S/N 7AC-4074

Back to AD 2000-25-02 R1