OpenAirDocs.org
AD 2000-25-02 R1

Registered aircraft · 7,561

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.

N27WHAviators Unlimited Aviation Holdings LLC · Garner, NCBuilt 2007 · S/N 1045-2007N27WKWillkris Aviation Services LLC · Smithfield, VABuilt 1972 · S/N 250-72N2802EMerritt Hal · Hilliard, FLBuilt 1946 · S/N 7AC-6386N2804EHingtgen Ricky L · Rincon, GABuilt 1946 · S/N 7AC-6385N2804ZWatson Jennifer R · San Jose, CABuilt 1978 · S/N 371-78N2808ELock Aaron S · Lebanon, OHS/N 7AC-6391N280MAMcgarity Daniel Scott · Essex, MOBuilt 2004 · S/N 4552004N2811EMorris Gordon K · Bruce, WIBuilt 1946 · S/N 7AC-6394N2811GNablo Dustin · Haddam Neck, CTBuilt 1967 · S/N 170N2814ETranby Todd D · Minot, NDBuilt 1946 · S/N 7AC-6397N2815ZBarnhill Daniel D · Robertsdale, ALBuilt 1978 · S/N 356-78N2816EMcdonald James · Terra Bella, CABuilt 1946 · S/N 7AC-6399N2818GRenda Joseph · Dunnellon, FLBuilt 1967 · S/N 515N2819EOverturf Sarah R · Iowa City, IABuilt 1946 · S/N 7AC-6402N2819ZHogan Thomas A · Fairfield, OHS/N 1236-78N281DMBalducki James B · Signal Hill, CABuilt 1999 · S/N 1258-99N281PCBlair Bobby G · Essex, MOBuilt 2003 · S/N 1342-2003N2820EWhitmore Masterson Eleanor Blythe · Terlingua, TXBuilt 1946 · S/N 7AC-6403N2822EBasler Leon E · Sainte Genevieve, MOBuilt 1946 · S/N 7AC-6405N2826EBennett Randy A · Hickman, CABuilt 1946 · S/N 7AC-6409N2827EBrown Michael C · Hastings, MIBuilt 1946 · S/N 7AC-6410N2828CS C Inc Of USA · Rydal, PABuilt 2003 · S/N 1343-2003N2828EWhittington William M III · Greenwood, MSBuilt 1946 · S/N 7AC-6411N2828GSparrow Hawk Aviation LLC · Moraine, OHS/N 84N282MAJ&D Aviation LLC · Dallas, TXBuilt 2004 · S/N 959-2004N2830DLoyd Chris L · Spring, TXS/N 11AC-275N2830GSandoval Jennifer · Tucson, AZBuilt 1967 · S/N 351N2831GJohnston Skippy W · Fairbanks, AKBuilt 1967 · S/N 57N2832GFields Michael L · Rockwood, TNBuilt 1967 · S/N 475N2834EMarkes Cecelia T · Kearney, NEBuilt 1946 · S/N 7AC-6417N2839GGereg James J · Danbury, CTFirst renewal noticeBuilt 1967 · S/N 65N283MBOakwood Air LLC · Sioux Falls, SDBuilt 2003 · S/N 1345-2003N2840EBartholomew William Taylor · Louisburg, NCS/N 7AC-6423N2841EEllingson Leslie B · Harwood, NDBuilt 1946 · S/N 7AC-6424N2843ECouvillion Rickey J · Lafayette, LABuilt 1946 · S/N 7AC-6426N2846ESchmid Gerhard G · New Smyrna Beach, FLBuilt 1946 · S/N 7AC-6429N2847DAlthens Levi W · Wasilla, AKS/N 7BCM-51N2847EChipman Jeff M · Rising Sun, INBuilt 1946 · S/N 7AC-6430N2848EBeckhoff Allen C · Greybull, WYBuilt 1946 · S/N 7AC-6431N2850GSlip And Skid LLC · Sanger, TXS/N 510N285DM4 Play Aviation LLC · Port Orange, FLBuilt 1997 · S/N 1236-97N2860EShaffer Barbara J · Franklin, KYBuilt 1946 · S/N 7AC-6443N2866EBaumler George C · Louisville, KYBuilt 1946 · S/N 7AC-6449N2868ZWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1978 · S/N 1237-78N2869EFirst Flight Corp · San Diego, CABuilt 1946 · S/N 7AC-6452N2869GRay Richard A · Morristown, NJBuilt 1967 · S/N 533N2871EKoedel Greg A · Hamilton, OHBuilt 1946 · S/N 7AC-6454N2872EEasterwood William D · Hermitage, TNBuilt 1946 · S/N 7AC6455N2875EEdmonds Laura P · Alburg, VTBuilt 1946 · S/N 7AC-6458N2876GPalmer Matthew B · Riverside, CABuilt 1967 · S/N 522-68
Back to AD 2000-25-02 R1