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

N88476Bmg Aviation Inc · Bloomington, INBuilt 1974 · S/N 495-75N88477Holland William T III · Midway, ARBuilt 1974 · S/N 136-75N884JSCrane John R · Niceville, FLBuilt 1977 · S/N 340-77N8857Aviation Management Systems LLC · Fallbrook, CABuilt 1973 · S/N 254-73N8861Farabaugh Nano F · Elkhart, INBuilt 1973 · S/N 71-73N8868Hodges Jay W · Graham, TXBuilt 1973 · S/N 931-73N886THMock Joseph R · Huntsville, TXBuilt 1974 · S/N 142-74N887BCAustin Aviation LLC · Boise, IDBuilt 2023 · S/N 627-2023N887PAReall George Dan · Castle Rock, COBuilt 2016 · S/N 1162-2016N8883Harris James H · Gardner, KSBuilt 1973 · S/N 932-73N8888NGibson Edward J · Marmora, NJBuilt 1967 · S/N 7KCAB-58N8894Buth Elizabeth · Wasilla, AKBuilt 1973 · S/N 478-73N8896Ausbun Taylor J · North Pole, AKBuilt 1973 · S/N 480-73N8897Cavett Wanda A · Enderlin, NDS/N 934-73N889GSKlock Dexter F · Driggs, IDBuilt 2000 · S/N 853-99N88AOgden Christopher S · Chewelah, WABuilt 1958 · S/N 7FC-209N88EVCarrier Timothy E · Waynesville, OHBuilt 1972 · S/N 64-72N88LLLarrabee Consulting Group LLC · West Carrollton, OHBuilt 1977 · S/N 973-77N88NVPhillips Mark L F · Albuquerque, NMFirst renewal noticeS/N 1287-79N88SSWasson Trevor J · Whitewater, MTBuilt 1976 · S/N 205-76N8901RStanton Andrew J · Platte City, MOS/N 7FC-369N8902RLaney Charles A · Maiden, NCBuilt 1959 · S/N 7AC-16N8906RFlynn Andrew L · La Grande, ORBuilt 1960 · S/N 7HC-26N8910RBatto Jeannie L · Madison, INBuilt 1959 · S/N 7EC-716N8912RDay Kimberly K · Grand Rapids, MNBuilt 1959 · S/N 7EC-715N8914RAgaliotis Paul E · San Martin, CABuilt 1959 · S/N 7HC-19N8917RDyke Milo O · Hazen, NDBuilt 1960 · S/N 7EC-727N8918RDoolittle Philip E · Dunmore, WVBuilt 1959 · S/N 7HC-20N891DBSpivak Maxim · San Jose, CABuilt 2001 · S/N 891-2001N891JTTrowbridge Jason Wesley · Arlington, TNBuilt 1973 · S/N 584-80N8921RPotters Aviation LLC · Haskell, OKBuilt 1960 · S/N 7GCA-168N8922Culver Marc D · Anchorage, AKBuilt 1973 · S/N 493-73N8923Brockway Troy D · Salina, KSBuilt 1973 · S/N 481-73N8924RMachler Lance J · Murphys, CABuilt 1959 · S/N 152N8926Johnson David H · Jasper, GABuilt 1973 · S/N 367-73N8927Bevis Kenneth D · Richwood, OHS/N 48273N8928Anding Jay B · Bryan, TXBuilt 1973 · S/N 483-73N8929Cavanagh James B · Litchfield Park, AZBuilt 1973 · S/N 255-73N8930RSierra Aeronautics LLC · Gambier, OHFirst renewal noticeS/N 7FC380N8933RThrall Gregory D · Seward, AKBuilt 1959 · S/N 7GC-159N8935RHansen Jed D · Clark, SDS/N 7FC-379N8936RHilbert Robert C · Marengo, ILBuilt 1960 · S/N 7JC9N8938RPoklar Norman A · Mount Orab, OHS/N 7FC-381N8939RJohnston James D · Tillamook, ORBuilt 1960 · S/N 7HC-23N8941RHamme Curtis S · Bedford, TXBuilt 1960 · S/N 7HC-24N8942RRichards Penny L · Saint Jo, TXBuilt 1959 · S/N 7FC-382N8944Bundy John F · Hamilton, MTBuilt 1973 · S/N 608-74N8945RBehne Eric D · Brentwood, CAS/N 162N8946Cox Paul Bartlett · Granbury, TXBuilt 1973 · S/N 407-74N8946RWatson Bobby M · Hoxie, ARBuilt 1960 · S/N 7FC-384
Back to AD 2000-25-02 R1