OpenAirDocs.org
AD 2004-25-16 R1

Registered aircraft · 10,537

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:2004-25-16-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:2004-25-16-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.

N303JPJep Inc · Clarksville, TNBuilt 1982 · S/N T30300067N303KJBrother Michael Andrew · Bedford, TXBuilt 1984 · S/N T303-00301N303KSSmoky Hill Ag LLC · Healy, KSBuilt 1982 · S/N T30300223N303MBBas Part Sales LLC · Greeley, COBuilt 1982 · S/N T30300157N303MMBrown Properties Of Ga Inc · Silver Creek, GABuilt 1977 · S/N 34-7870027N303PABird Acquisition LLC · Phoenix, AZBuilt 2002 · S/N 4496122N303PBPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N T30300290N303RCYogini Modi · Homestead, FLBuilt 1971 · S/N 34-7250016N303RMGiesbrecht Shane · Grandview, IDBuilt 1969 · S/N TC-1219N303TSCheyenne Air LLC · Ocean City, NJBuilt 1981 · S/N 31T-8166007N303WAWacker Logistics LLC · Naples, FLBuilt 1984 · S/N T30300265N303WJQualitair LLC Trustee · MichelstadtBuilt 1982 · S/N T30300087N303WWQualitair LLC Trustee · MichelstadtBuilt 1983 · S/N T30300226N3040LLuft Inc · North Fort Myers, FLS/N 310J0040N3041TSouthern Oregon Skyways Inc · Medford, ORBuilt 1964 · S/N 320C0041N3042LMsl Holdings · Newbury Park, CABuilt 1965 · S/N 310J0042N3042TKls Enterprises Inc · Cave Creek, AZBuilt 1964 · S/N 320C0042N3043TJwt Aviation LLC · Yancey, TXBuilt 1964 · S/N 320C0043N3044W625 Mike Tango LLC · Dickinson, TXBuilt 1973 · S/N TH-344N3047BOregon Aero Academy Inc · Albany, ORBuilt 1978 · S/N 44-7995113N3048Speck Michael A · Friendswood, TXBuilt 1972 · S/N 33701470N3048LLuster Maurice A Jr · Miami Beach, FLS/N 310J0048N3048PMeginnes Mark A · Tucson, AZBuilt 1957 · S/N 23-959N3048RAlbert Lea Airport Inc · Albert Lea, MNBuilt 1979 · S/N 44-7995242N3048YAeronautica LLC · West Hollywood, CAS/N 34-7970196N3049DAnchor Equipment Leasing LLC · Covington, KYBuilt 1998 · S/N TH-1873N3049PTaildragger Aero LLC · Saint John, WABuilt 1957 · S/N 23-961N304JWVega Air LLC · Pigeon Forge, TNS/N 340A-1250N304MCValiair Lc Trustee · Casper, WYS/N 421B0130N3050LMadison Mitchell · Guthrie, OKBuilt 1965 · S/N 310J0050N3050TLand T Chat · Tulsa, OKBuilt 1964 · S/N 320C0050N3051TPacific Arts Collection LLC · Oakland, CAS/N 320C0051N3051XWagner Richard L · Conroe, TXBuilt 1979 · S/N 34-7970190N30521Sale Reported · New Bern, NCSale reported, pending cancellationBuilt 1978 · S/N 44-7995076N3052DAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1978 · S/N 44-7995144N3054KFerguson David G · Woodbridge, VABuilt 1979 · S/N 34-7970102N3055TTechnical Education Services · Virginia Beach, VABuilt 1965 · S/N 320C0055N3056LFowler Larry K · Harrison, ARBuilt 1965 · S/N 310J0056N3057VBig H Transportation LLC · Traverse City, MIBuilt 1979 · S/N 34-7970168N3058ROn Top Aviation LLC · Salinas, CABuilt 1998 · S/N TH-1870N305CABrinker Joe E Jr · Little Hocking, OHBuilt 1964 · S/N TC-584N305WP3192 Golf Inc · Wauchula, FLBuilt 1984 · S/N TH-1426N305WRKnudsvig Travis · Waterloo, IABuilt 1973 · S/N TC-1591N305YWRichard L Richards P A Trustee · Coral Gables, FLBuilt 1977 · S/N 31-7852016N30608Christiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 4496180N30619Wrpl LLC · Mountain Brk, ALBuilt 1978 · S/N 34-7870467N3063PWillis William P Trustee · New Palestine, INS/N 23-981N3066BAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1987 · S/N TH-1514N3066DN3066d LLC · Pompano Beach, FLBuilt 1998 · S/N TH-1866N3066PMatanane Rokie C · Barrigada, GUBuilt 1957 · S/N 23-984
Back to AD 2004-25-16 R1