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
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.

N4602EBring Jesse L · Galesburg, NDBuilt 1949 · S/N 7CCM-172N4605EAir Dakota Flite · Hettinger, NDBuilt 1949 · S/N 7CCM-175N46071Gilt Michael F · Raleigh, NCBuilt 1945 · S/N 7AC-25N4608ECovey Keith L · San Angelo, TXBuilt 1949 · S/N 7CCM-181N4609EFinseth Lowell J · Fountain, MNBuilt 1949 · S/N 7CCM-179N460ACArizona Skies Aviation LLC · Scottsdale, AZBuilt 2000 · S/N 440-2000N460LMMassey Larry A · New Braunfels, TXBuilt 1977 · S/N 321-77N4610EIllies David P · Fosston, MNBuilt 1949 · S/N 7CCM-176N4611DMaki Duane G · Wirt, MNBuilt 1946 · S/N 11AC-1431N4613EPangerl Gary D · Mora, MNS/N 11CC-262N461ACTucker Gary · Georgetown, TXFirst renewal noticeBuilt 2000 · S/N 439-2000N461BGDangelo John A · Dallas, TXBuilt 1996 · S/N 1213-96N461DMBryn Jamie P · Dazey, NDBuilt 2000 · S/N 426-2000N4624EDickens David B · Americus, GAS/N 7CCM-193N4626EPapen Bruce G · Hardtner, KSBuilt 1949 · S/N 7CCM-195N4627ENickels Steve A · Fort Peck, MTS/N 7DC-161N4628ERezabek Richard A · New Meadows, IDBuilt 1949 · S/N 11CC-266N4629ESmith Kevin J · Littlefield, TXS/N 7CCM-196N462TAeronca Flyers Inc · Wilmington, DEBuilt 1956 · S/N 7EC-510N4630EBokma Alan S · East Wenatchee, WABuilt 1949 · S/N 7CCM-197N4634EGhafouri Carly · Murrieta, CABuilt 1949 · S/N 7CCM-200N4635EUchimoto Daniel Y · Fayetteville, WVBuilt 1949 · S/N 7CCM-202N4642ESeleg Jonathan · Rosebud, MTBuilt 1949 · S/N 7CCM-208N4643EScheff David A · Marcell, MNBuilt 1949 · S/N 7CCM-209N4646EMeffert Lloyd A · Cotter, ARBuilt 1946 · S/N 7AC-2452N464SCCourtney Melissa · Okemos, MIBuilt 1999 · S/N 844-99N4652ERalston Roger A · Grand Rapids, MNBuilt 1950 · S/N 7EC-3N4653ERossland David T · Williston, NDBuilt 1950 · S/N 7EC-5N4654EMakely Abraham M · Culpeper, VAS/N 7DC-167N4656GFoss Jared K · Greenbush, MNBuilt 1957 · S/N 7EC 598N4657ENystrom Bay Farm Partnership · Pierre, SDBuilt 1950 · S/N 7EC-7N4658ELund Clayton L · Cheboygan, MIBuilt 1950 · S/N 11CC-274N4659EMichigan Tail Draggers LLC · Macomb, MIBuilt 1950 · S/N 7EC-8N465ACBlue Super D LLC · Clark, NJBuilt 1999 · S/N 827-99N4660EKuhn Marwynne G · Hilltop Lakes, TXBuilt 1950 · S/N 7EC-9N4664KWoods Edwin N · Santa Maria, CABuilt 1946 · S/N 7AC-3565N4666EWells Kris G · Barron, WIS/N 7EC-14N4667ESteffen James R · Washta, IABuilt 1950 · S/N 7EC-15N466DSDrummond Michael S · Lewisville, NCBuilt 1978 · S/N 352-78N466SC123 Investments LLC · Clare, MIBuilt 2020 · S/N 1186-2020N4672EKajans Douglas L · Reno, NVBuilt 1950 · S/N 7EC-27N4677EStults Christopher · Wray, COBuilt 1950 · S/N 7EC-25N4678ENorthwind Capital Holdings Inc · Anchorage, AKBuilt 1950 · S/N 7EC-26N4679E3218t Inc · Omaha, NEBuilt 1950 · S/N 7EC-28N467ACFunk Herman L · Stanberry, MOBuilt 1946 · S/N 7AC-2570N467DFreeman William A · Melbourne, FLS/N 7AC7192N467JJBurch Patricia E · Brookville, INBuilt 1945 · S/N 7AC-310N467KCPrestar Inc · Davis, CABuilt 1946 · S/N 7AC-2838N4680EJohnson Keith M · Creswell, ORBuilt 1950 · S/N 7EC-29N4681EStrahan Ronald R · Girard, KSBuilt 1950 · S/N 11CC-276
Back to AD 2000-25-02 R1