OpenAirDocs.org
AD 87-21-02 R1

Registered aircraft · 3,961

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-21-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:87-21-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.

N3309QB & R Aerial Crop Care Inc · Connell, WABuilt 1966 · S/N 320D0109N3309XCabanas Alexis Santiago · Stroudsburg, PAS/N 310L-0159N330MRJett Aviation LLC · Clovis, NMBuilt 1979 · S/N 340A0721N3310DGrewe Mike · Lake In The Hills, ILBuilt 1972 · S/N 310Q-0630N3313XBowman Cody · Brooklyn, MIBuilt 1967 · S/N 310L-0163N3314XGalloway James D · Whitmore Lake, MIS/N 310L0164N3315QTcf Ventures LLC · Wilmington, DEBuilt 1966 · S/N 320D0115N3315XElberg Paul · Aventura, FLBuilt 1967 · S/N 310L0165N3316QPerson Michael · West Chester, PABuilt 1966 · S/N 320D0116N3317QSkynight 17q LLC · Roseville, CABuilt 1966 · S/N 320D0117N3318Q2400 Rickenbacker LLC DBA · Auburn, CABuilt 1966 · S/N 320D0118N3319QNeuschaefer George H · White Hills, AZBuilt 1966 · S/N 320D0119N331BXFay Craig J · Fairfax Station, VABuilt 1967 · S/N 310L-0168N331LSTechnical Education Services Inc · Virginia Beach, VABuilt 1969 · S/N 310Q0028N331TCOn Trend Homes LLC · Columbia, MOS/N 414-0943N3321MMaxray Aviation LLC · Ashland, OHBuilt 1978 · S/N 310R1343N3321XPatton Aviation LLC · Billings, MTS/N 310L-0171N3322XAllgood Michael K · Saint Augustine, FLBuilt 1974 · S/N 310Q1030N3325QWinrick LLC · Flagstaff, AZS/N 320D0125N3327XTrimble Anthony W · Weatherford, TXBuilt 1967 · S/N 310L-0177N3330XMylin LLC · Havre De Grace, MDS/N 310L-0180N3333MFun Tickets LLC · Manchester, MEBuilt 1981 · S/N 340A1229N3335XPfeiffer Engineering LLC · Boonville, MOBuilt 1967 · S/N 310L-0185N3339XWestfall Michael T · Woodstock, GABuilt 1967 · S/N 310L-0189N333AMLally Glen Joseph · Pleasanton, CABuilt 1975 · S/N 414-0651N333CJDrj Aviation LLC · Dover, DEBuilt 1972 · S/N 421B0313N333ESRebus LLC · Andover, KSS/N 310Q0232N333HHJohnson Craig A · Canton, TXS/N 414-0942N333JCHunter Prim LLC · Bolingbroke, GABuilt 1967 · S/N 310L-0197N333KWD G R Air LLC · Braselton, GABuilt 1974 · S/N 421B0657N333PWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N 414A0525N333SFFerretti James L III · Port Orange, FLBuilt 1967 · S/N 411-0260N333UDSpecialty Aero LLC · Seattle, WABuilt 1981 · S/N 340A1256N333WDWoelbing Aviation LLC · Franksville, WIBuilt 1966 · S/N 310L-0002N3340XVito Bavaro Construction Inc · Escalon, CAS/N 310L-0190N3341XJackson Rex A · Granbury, TXBuilt 1967 · S/N 310L-0191N3345XTurel Gary J · Tigard, ORS/N 310L-0195N334NCarter-Muthana Aero LLC · Bakersfield, CABuilt 1978 · S/N 421C0458N3354QOn The Beam Aviation Inc · Hampton, GABuilt 1967 · S/N 310L-0204N3355QSunshine Aircraft Repair Inc · Lindenhurst, ILS/N 310L-0205N335CMPura Plastic Surgery LLC · Doral, FLBuilt 1980 · S/N 414A0418N335DDJab Aviation Inc · Wilmington, DEBuilt 1980 · S/N 335-0049N335KHSerafini Transportation LLC · Ringwood, NJBuilt 1979 · S/N 335-0025N335PCOcow LLC · Jenks, OKBuilt 1980 · S/N 335-0053N335PW335 Leasing LLC · Englewood, COS/N 335-0011N335SMMf Property Management LLC · Hattiesburg, MSBuilt 1979 · S/N 3350020N335TJYork Michael · Reston, VABuilt 1979 · S/N 335-0012N335TSHague Neil C · Wichita, KSS/N 335-0026N3364LLopez Edwin · Germantown, TNS/N 310Q0784N3376GLindsay Aviation Inc · West Seneca, NYBuilt 1976 · S/N 310R0818
Back to AD 87-21-02 R1