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.

N5506CBattle Creek Powersports LLC · Jasper, TNBuilt 1978 · S/N 1267-78N5506HWoods George M · Anchorage, AKS/N 1240-78N5506MCloud Kicker Aviation LLC · Kalamazoo, MIBuilt 1978 · S/N 1040-78N5506ZOakcrest Management Inc · Brownsville, TXBuilt 1978 · S/N 364-78N55072Lorenzo John V · Tulare, CABuilt 1978 · S/N 1269-78N5507HAdair Caden S · Anchorage, AKBuilt 1978 · S/N 1273-78N5507PMccleskey Nicholas J · Mcminnville, ORBuilt 1978 · S/N 1043-78N5507WBurnett Fred · Greenbrier, ARBuilt 1978 · S/N 365-78N5507YPhillips John · West Jefferson, NCS/N 1044-78N5508JPaetzold Larry E · Brownwood, TXBuilt 1978 · S/N 1048-78N5508LDe Lint Marcus W · Cove, ORBuilt 1978 · S/N 1049-78N5508MLindvig Thomas H · Williston, NDBuilt 1978 · S/N 1272-78N5509NDelaney George W · Mineral Point, WIBuilt 1947 · S/N 7AC-6831N5517KCarter Brantley F · Timmonsville, SCBuilt 1978 · S/N 1253-78N5518KDiaz James F · Campbell, CAS/N 1024-78N5520KHillstrom Rudolph A · Oakville, WABuilt 1978 · S/N 385-78N5521KBrowning Ricou R Jr · Melbourne, FLBuilt 1978 · S/N 386-78N5525KMacomber Donald Conrad · Santa Ynez, CABuilt 1978 · S/N 1025-78N5526KOn-Site Aviation Inc · Hillsboro, NDBuilt 1978 · S/N 273-78N5528KGates Steven S · Midlothian, TXBuilt 1978 · S/N 388-78N5529KFloren Donald D · Royal City, WABuilt 1978 · S/N 1255-78N552DMRedstone Aero LLC · Chesterfield, MOBuilt 2005 · S/N 984-2005N5534KAerolife Aviation LLC · Knox, INBuilt 1978 · S/N 1028-78N5535KHays Cory · Beaumont, TXBuilt 1978 · S/N 390-78N5537KSales First LLC · Jasper, GABuilt 1978 · S/N 392-78N5538KHilowitz Andrew J · Anchorage, AKBuilt 1978 · S/N 1045-78N553JACerulean Skies Aviation LLC · Jacksonville, FLBuilt 1946 · S/N 7AC-568N553SFSmith Nancy R · Duluth, MNBuilt 1966 · S/N 247N5540KTymczyszyn William R · Torrance, CABuilt 1978 · S/N 394-78N5543KClassic Aviation LLC · Richmond, MIBuilt 1978 · S/N 1256-78N5544KZollars Thomas B · Dallas, TXBuilt 1978 · S/N 396-78N5545KSchroder Bernd · Brownsville, CABuilt 1978 · S/N 1031-78N554DKRvest Management LLC · Boulder City, NVS/N 502-2007N5551KSchlamer Robert B · Hernando, FLBuilt 1978 · S/N 400-78N5552KMob Aviation LLC · Auburndale, FLBuilt 1978 · S/N 1257-78N5556JLust Troy A · Humeston, IABuilt 1948 · S/N 7CCM-201N555ACHawk Aviation LLC · Springville, NYBuilt 2011 · S/N 531-2011N555AWRamakrishna Murali DBA · Malden, MABuilt 2010 · S/N 536-2010N555BJGypsy Aviation LLC · Newnan, GAS/N 182N555HEDetert Bradley · Valparaiso, INBuilt 1999 · S/N 848-99N555JKTenhoopen Thomas W · Livonia, MIBuilt 1973 · S/N 282-74N555XDXd Aviation LLC · Castle Rock, COBuilt 2013 · S/N 1135-2013N556RWEhrlich Randall V · Greenwich, CTBuilt 2010 · S/N 1093-2010N557ECAirborne One LLC · Kalispell, MTS/N 7EC-345N5581LJuhl Timothy G · Carsonville, MIS/N 7AC-6231N5581NGwaltney Max · Woodstock, GAS/N 48-504N558MASanders Flight Training Center Inc · Jasper, ALBuilt 2005 · S/N 991-2005N559BCEllison James Carl · Norman, OKBuilt 2015 · S/N 567-2015N55AMAdams Floyd R · Sebring, FLBuilt 1966 · S/N 362N55DZHuey Christopher D · Mesa, AZS/N 9472004
Back to AD 2000-25-02 R1