AD 2002-07-01

Registered aircraft · 3,466

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

N67DGD&B Aircraft Leasing LLC · Anchorage, AKBuilt 1974 · S/N U20602375N67DJSunrise Aero LLC · Nikiski, AKBuilt 1974 · S/N U20602326N67EPViner Kevin Patrick · Encinitas, CAS/N P21000032N67JAJaars Inc · Waxhaw, NCBuilt 1980 · S/N U20605781N67JKInternational Air Services Inc Trustee · Carson City, NVS/N P21000684N67VMCreeque Alley Ventures LLC · Missoula, MTBuilt 1980 · S/N P21000568N67XLDavid E Morris Sr Enterprises LLC DBA · Mountainburg, ARBuilt 1983 · S/N P21000815N6802RStahla Robert E Trustee · Grand Island, NEBuilt 1966 · S/N T210-0202N6803RN6803r LLC · Kent, OHBuilt 1966 · S/N T210-0203N6808NSwan Air LLC · Perham, MNS/N 21063154N6816BMystic Dreams LLC · Mount Juliet, TNBuilt 1978 · S/N 21062837N6824RSquadron 5 Inc · Saratoga, CABuilt 1966 · S/N T210-0224N6826BDan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1978 · S/N 21062840N6830RElizalde Carla Zankiz · Estero, FLBuilt 1967 · S/N T210-0230N6831MSouth Beach Adventure Sports LLC · Bald Head Island, NCBuilt 1977 · S/N 21061994N6832RWheeler David G Jr · Chico, CAS/N T210-0232N683JWLotela Partners LLC · Avon Park, FLBuilt 1980 · S/N 21063982N6843RArkansas Air LLC · Jackson, WYBuilt 1966 · S/N T210-0243N6847RAlpine Aviation LLC · Oklahoma City, OKFirst renewal noticeBuilt 1967 · S/N T210-0247N684MCT&B Aero LLC · Jacksonville, FLS/N 21061604N684SSecond Wind Aviation Corp · Friday Harbor, WABuilt 1969 · S/N 20700147N6850BJennings Donald J · Gypsum, COS/N 21062845N6851R6851r LLC · Greeley, COS/N T210-0251N6852RJensen Sid R · Idaho Falls, IDBuilt 1967 · S/N T210-0252N6855RD & N Holdings Inc · Boca Raton, FLBuilt 1967 · S/N T210-0255N6857RRegistered aircraftBuilt 1967 · S/N T210-0257N6859RRomeo Airmotive LLC · Stockton, CABuilt 1967 · S/N T210-0259N685GTEatmb Air Inc Trustee · Wilmington, DEBuilt 1979 · S/N 21063361N685SSecond Wind Aviation Corp · Friday Harbor, WABuilt 1970 · S/N 20700184N6861RJohnson Bradley Michael · Belgrade, MTBuilt 1967 · S/N T210-0261N6864RRankin Bryan · Cloverdale, CABuilt 1967 · S/N T210-0264N6866ROrnes W Harold · Aiken, SCBuilt 1967 · S/N T210-0266N6868RChrisman Charles Griggs · Denver, COS/N T210-0268N6870MApplied Science Services Corp · Woodland Hills, CABuilt 1977 · S/N 21061998N6889RShelton L Wayne · Rifle, COBuilt 1967 · S/N T210-0289N6899BCowgill Robert W · Amissville, VABuilt 1978 · S/N 21062852N68BMDavenport Donald · North Las Vegas, NVBuilt 1977 · S/N 21062441N68JFAjs Aviation LLC · Warroad, MNS/N U20606728N68MGDreger Dean R · Wilbur, WABuilt 1981 · S/N 21064392N68NQRounds Dana H · Vacaville, CABuilt 1976 · S/N U20603399N68TBSmith Ronald A · Los Gatos, CABuilt 1981 · S/N 21064492N6900XMueller Robert C · Reno, NVBuilt 1977 · S/N 21062392N6901RFritz Douglas R · Anacortes, WABuilt 1967 · S/N T210-0301N6908MGrant Aviation Inc · Anchorage, AKBuilt 1980 · S/N 20700672N6909RMitchell Greg · Pecos, TXBuilt 1967 · S/N T210-0309N6910RDirty Birdy Aviation LLC · Silt, COBuilt 1967 · S/N T210-0310N691MSSharptime LLC · Bossier City, LAS/N 20700514N6924RTurbo Centurion LLC · Vail, AZBuilt 1967 · S/N T210-0324N6925RDelong Mark B · Rock Springs, WYBuilt 1967 · S/N T210-0325N6927BKryptonite Industries LLC · Golden, COBuilt 1978 · S/N 21062853
Back to AD 2002-07-01