OpenAirDocs.org
AD 87-24-07 R1

Registered aircraft · 206

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:87-24-07-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:87-24-07-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.

N400DSSpur Aviation Services Lc · Twin Falls, IDBuilt 1978 · S/N 11512N40SMCo Fire Aviation Leasing Inc · Fort Morgan, COBuilt 1979 · S/N 11559N420LWCrazy Horse LLC · Princeton, WVS/N 11455N425DTSun Fast Inc · Mansfield, TXBuilt 1978 · S/N 11519N444WDFlyto LLC · Indianapolis, INBuilt 1988 · S/N 96006N449LCTj Air Holdings Inc Trustee · Wilmington, DES/N 11187N44NCPonderosa Aviation LLC · Safford, AZBuilt 1977 · S/N 11387N45AZPonderosa Aviation LLC · Safford, AZBuilt 1977 · S/N 11383N4717VCourtney Aviation LLC · Columbia, CAS/N 11220N479PTT Enterprises Inc · Jackson, MSBuilt 1981 · S/N 96011N47EPRum Bum Distributors Inc · Miami, FLBuilt 1978 · S/N 11520N47TTLon Air LLC · Miles City, MTBuilt 1979 · S/N 11600N480KSpur Aviation Services Lc · Twin Falls, IDBuilt 1976 · S/N 11543N48BANjia Air LLC · Montgomery, INS/N 11665N5016HBest Aircraft Deals LLC · Salt Lake City, UTS/N 11452N50DXYada Yada Yada Inc DBA · Fresno, CABuilt 1974 · S/N 11227N515AMAllen Myland Inc · Media, PABuilt 1980 · S/N 95008N51DMJersey Ordnance Inc · Westampton, NJBuilt 1981 · S/N 96014N51WFD&S Aircraft LLC · Gainesville, GABuilt 1981 · S/N 11684N52JWJ W Aviation LLC · Dover, DES/N 11619N52PYJk Aviation LLC · Carson City, NVS/N 11196N53GEWings & Rotors LLC · Wilmington, DES/N 11404N555VEPia Avcenter LLC · Peoria, ILBuilt 1979 · S/N 11546N559CGOrtiz Luis Emerito Nieves · Ciudad De PanamaNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 11530N55WJCo Fire Aviation Leasing Inc · Fort Morgan, COBuilt 1977 · S/N 11427N57112Courtney Aviation LLC · Columbia, CABuilt 1975 · S/N 11263N57RSKolob Canyons Air Services Inc · Wilmington, DES/N 11149N57TBInternational Air Services Inc Trustee · Carson City, NVS/N 11613N580ERBlue Ocean Aerospace LLC · Fort Collins, COBuilt 1981 · S/N 11669N586DVFlying A Flight Service LLC · Safford, AZBuilt 1979 · S/N 11553N5878KClearwater Airco LLC · Anchorage, AKBuilt 1980 · S/N 11626N5926KGulfstream Aerospace Corp · Savannah, GABuilt 1981 · S/N 11674N5955KVolare Via LLC · Piqua, OHBuilt 1981 · S/N 11703N5956KSullivan Leo · Ofallon, ILS/N 11719N600PSPlane Services LLC · Twin Falls, IDS/N 11537N601WTNickel Family LLC · Bakersfield, CABuilt 1982 · S/N 15016N60BMValiair Lc Trustee · Casper, WYS/N 11172N615DPRay Aircraft Leasing LLC · Tuscaloosa, ALBuilt 1976 · S/N 11317N63DUCts Aviation Inc · Galesburg, MIBuilt 1979 · S/N 11601N64PSSchiff Peter · Cookeville, TNBuilt 1981 · S/N 11702N66GWKolob Canyons Air Services Inc · Wilmington, DES/N 11174N674NMMartin Nicolas · Rolling Hills, CABuilt 1974 · S/N 11226N67CG1 Blue Sky LLC · Miami, FLBuilt 1979 · S/N 11540N67WGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1982 · S/N 96052N690AGCay Air LLC · Wilmington, DEBuilt 1976 · S/N 11327N690ARPonderosa Aviation LLC · Safford, AZBuilt 1974 · S/N 11155N690ASAero Commander N690as LLC · Kalispell, MTBuilt 1974 · S/N 11277N690AWPeter Claire Pty Ltd · GeorgetownBuilt 1977 · S/N 11438N690AXPia Avcenter LLC · Peoria, ILBuilt 1977 · S/N 11384N690BGN690bg LLC · San Angelo, TXBuilt 1977 · S/N 11381
Back to AD 87-24-07 R1