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.

N9318EAirpower Museum Inc · Ottumwa, IABuilt 1946 · S/N 11AC-956N9324EAnderson Timothy H · Janesville, WIBuilt 1946 · S/N 11AC-962N9325HBrown Richard S · Moon Township, PAS/N 47-807N9327HBealer David C · Bethlehem, PABuilt 1947 · S/N 7BCM-318N9328ERichie James A · Pleasant View, TNBuilt 1946 · S/N 11AC-966N9329EVan Winkle Randy M · Van Buren, MOS/N 11AC-967N9330HHrutkay Charles S · Scenery Hill, PABuilt 1947 · S/N 7BCM-249N9331ECimprich Joseph P · Camden, OHBuilt 1946 · S/N 11AC-969N9333EObrien Stephen F · Manley Hot Springs, AKBuilt 1946 · S/N 11AC-972N9334ELisch Timothy F · Delavan, WIS/N 11AC-971N9336EWagner Dean M · Bellevue, WABuilt 1946 · S/N 11AC-974N933BCPathak Rahul · Mercer Island, WABuilt 2024 · S/N 1219-2024N9342EWilson Kenneth D · Warsaw, MOBuilt 1946 · S/N 11AC-992N9344EDodd Jason R · Pittsboro, INBuilt 1946 · S/N 11AC-982N9345EGundersen Paul M · Polson, MTBuilt 1946 · S/N 11AC-983N9346EBarthule Jacob E · Roundup, MTS/N 11AC-984N9349ELittle Colin J · Bidwell, OHS/N 11AC-986N9351EBrown David L · Hicksville, OHBuilt 1946 · S/N 11AC-989N9354EMilheim Charles J · Watsontown, PABuilt 1946 · S/N 11AC-991N9355ELurie Allan H · Peoria, ILBuilt 1946 · S/N 11AC997N9357EWelling Charles E III · West Islip, NYBuilt 1946 · S/N 11AC-994N9361ERodkey John R · Goleta, CABuilt 1946 · S/N 11AC-999N9365EHoskins Robert · Castalian Springs, TNBuilt 1946 · S/N 11AC-1003N9367EBracken Phillip C · Frostproof, FLBuilt 1946 · S/N 11AC-1005N9369ELin Andrew H · Huntingtown, MDBuilt 1946 · S/N 11AC-1007N93711Perkins Herbert A · Kerrville, TXBuilt 2013 · S/N 1033-2013N9371EOrf Christopher D · Saint Peters, MOBuilt 1947 · S/N 11AC-1009N9373EFrick Gary A Trustee · Marion, INBuilt 1946 · S/N 11AC-1011N9381EHeavirland Patrick J · Roseville, MNBuilt 1946 · S/N 11AC-910N9382ESale Reported · Westmoreland, TNSale reportedS/N 11AC-1019N9384EHaley Billie Jo · San Martin, CABuilt 1946 · S/N 11AC-1021N9388EHendrix Charles K Jr · Dyersburg, TNBuilt 1946 · S/N 11AC1025N939ABTractorboyflys LLC · Sugar Land, TXBuilt 1998 · S/N 1369-98N939CBRegistered aircraftBuilt 1975 · S/N 207-75N93ACGwidt Mitchell A · Prior Lake, MNBuilt 2009 · S/N 1029-2009N93BCThorp Contractors LLC · Vinita, OKBuilt 2003 · S/N 456-2003N93BYPearce Ricky A · Parsons, KSBuilt 1968 · S/N 129N93DNRiseaero LLC · Florence, SCBuilt 1993 · S/N 712-93N93DTTolkach Dennis · Dunlevy, PABuilt 1993 · S/N 366-93N93GFRanieri Realdo · Mesa, AZBuilt 1993 · S/N 367-93N93SMVilla Aviation LLC · Alpharetta, GABuilt 2000 · S/N 1290-2000N93WEBoeing Employees Flying Assoc · Renton, WABuilt 1992 · S/N 659-92N93WKPiercy Ronald S · Moses Lake, WABuilt 1973 · S/N 643-74N9401EBurns Fletcher A · Heathsville, VABuilt 1946 · S/N 11AC1038N9404EMaloney Edward M · Coloma, MIBuilt 1946 · S/N 11AC-1041N9405EFenger Paul L · Cottonwood, MNBuilt 1946 · S/N 11AC-1042N9410ELopez Jesus · Cicero, ILBuilt 1946 · S/N 11AC-1047N9411ESky West Aviation Inc Trustee · Albuquerque, NMS/N 11AC-1048N9416EAllen George C · Upper Lake, CABuilt 1946 · S/N 11AC-1053N9417EKuhn Darrell G · Irma, WIBuilt 1946 · S/N 11AC-1054
Back to AD 2000-25-02 R1