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.

N5097JFencer Michael J · Wilmington, MAS/N 310R0217N5097QIntravaia Anthony J · Mountain View, CABuilt 1968 · S/N 310N-0197N5098QM&L Engine LLC · Schriever, LABuilt 1971 · S/N 340-0024N509DPX-Jet Logistics LLC · Chino Hills, CAS/N 310J0099N509RSHalf Shell Aviation LLC · Highlands Ranch, COBuilt 1978 · S/N 414A0060N50CBHughes Eugene F Jr · Butte, MTBuilt 1979 · S/N 414A0228N50DLSand Castle Management LLC · Wichita, KSBuilt 1973 · S/N 421B0526N50GBOviedo Juan M III · Oak Point, TXBuilt 1975 · S/N 340-0163N50GTThomas Richard E · Lafayette, TNBuilt 1964 · S/N 310I0095N50LWildcat Aeroplanes LLC · Sedalia, COBuilt 1977 · S/N 421C0431N50MAGoodhue David H · Vancouver, WABuilt 1979 · S/N 414A0434N50ZPPalen Mark T Trustee · Cleveland, TNBuilt 1975 · S/N 421C0022N5105JNickravesh Niknam John · Saratoga, CABuilt 1975 · S/N 310R0225N510NEAirswiss Inc · Wilmington, DEBuilt 1984 · S/N 402C1001N510SMGolden Leaf Tobacco Company Inc · Keysville, VAS/N 421C0112N510TFLang Eric O · Oklahoma City, OKBuilt 1978 · S/N 340A0499N510VParkes Craig · White Salmon, WAS/N 310L-0113N510WHCerniglia Paul J · Monroe Township, NJBuilt 1963 · S/N 310H0142N5110JArbogast Matthew G · Ooltewah, TNBuilt 1975 · S/N 310R0230N5111JValiair Ltd Co Trustee · Casper, WYBuilt 1975 · S/N 310R0231N511MBPosner Leo S · Ambler, PABuilt 1975 · S/N 310R0599N512HPN512hp LLC · Dover, DEBuilt 1974 · S/N 340-0324N512KZotec Partners LLC · Carmel, INBuilt 1978 · S/N 414A0054N5134CEzrydr LLC · Huntsville, ALBuilt 1982 · S/N 414A0852N5137JGrandair Aviation Inc · Grand Ledge, MIBuilt 1975 · S/N 310R0257N513DWright Aero Inc · Saint Cloud, MNBuilt 1976 · S/N 340A0048N513FSJackson Construction Services LLC · Wichita Falls, TXS/N 421C0510N513JNFly Area LLC · Charleston, SCS/N 421C0293N513SJWagner Distributing Co Inc · Auburn, CABuilt 1975 · S/N 421C0043N5140JTruk Err Inc · Wilmington, DEBuilt 1975 · S/N 340-0530N5147CMiller Ronald D · Hattiesburg, MSBuilt 1978 · S/N 310R1423N514LPInvader Aviation LLC · Tijeras, NMBuilt 1980 · S/N 414A0507N514NCHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0514N5151JHalverson Mechanical Inc · Ogden, UTBuilt 1975 · S/N 340-0541N5157JApogee Finance LLC · Fort Worth, TXBuilt 1975 · S/N 340-0547N515BTAir Safety Investigators LLC · Nokomis, FLS/N 340A1816N515DCmmk LLC · Talent, ORBuilt 1980 · S/N 340A-1022N515FVSlowmow Inc · Palestine, TXS/N 414-0410N515STQ&A Holdings LLC · Elkridge, MDBuilt 1971 · S/N 414-0169N5160JZemnickas William V · Metamora, MIS/N 340-0550N5163JQuantie Harold · Locust Grove, OKBuilt 1975 · S/N 340-0553N5165JPeak Wings LLC · Missoula, MTBuilt 1975 · S/N 340-0555N5169JPotter Kent W · Laurel, MTBuilt 1976 · S/N 340A0004N5175JAycock Charles C · Midland, TXS/N 340A0010N5178JSeven Eight Juliet LLC · Edmond, OKS/N 340A0013N517MHCbtm Aviation LLC · Leesburg, FLBuilt 1976 · S/N 421C0104N517RHRoyce Aviation LLC · Greenville, MSBuilt 1965 · S/N 310J0101N5181JForce One Inc · Missoula, MTBuilt 1975 · S/N 340A0016N5182JEmery & Associates Inc · Orangeville, PAFirst renewal noticeS/N 340A0017N518BBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 421B0518
Back to AD 87-21-02 R1