OpenAirDocs.org
AD 87-18-06 R1

Registered aircraft · 6,238

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-18-06-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-18-06-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.

N747DVUnrestricted Climb LLC · Muskego, WIBuilt 1996 · S/N E-3062N747DWAviation Trust Company LLC Trustee · Oklahoma City, OKS/N TH-2002N747GLoblolly Management LLC · Concord, NCBuilt 1998 · S/N E-3203N747PHFirst State Bancshares Inc · Middleberg, KYFirst renewal noticeBuilt 1988 · S/N TH-1533N747SBCloud Transport Operations LLC · Kalispell, MTBuilt 1980 · S/N TJ-297N747YVGreat Among The Nations Inc · Beverly Hills, CABuilt 1999 · S/N EA-642N749MRAfterburner Aerospace LLC · Belgrade, MTBuilt 1979 · S/N CE859N74AZHmaair LLC · Gilbert, AZBuilt 1982 · S/N E-2017N74BKWarner Thomas K · Monterey, CABuilt 2004 · S/N E-3532N74BPLowell Russell · Vonore, TNBuilt 1973 · S/N E-455N74BRBbj Aviators LLC · Springfield, ILBuilt 1997 · S/N E-3106N74BSSanditen Barry A · Austin, TXBuilt 1983 · S/N E-2069N74BTSta Aviation LLC · Wilmington, DEBuilt 1977 · S/N E984N74CBKendrick Paul · Atascadero, CABuilt 1974 · S/N D-9690N74DTEnjoy Life Flying LLC · Sunrise, FLBuilt 1999 · S/N EA-634N74LECarnes Eddy A · Uvalde, TXBuilt 1989 · S/N CE-1310N74MFCarl Raymond Baker LLC · Brenham, TXBuilt 1981 · S/N TJ-397N74MTKopair LLC · Saint Louis, MOBuilt 2000 · S/N EA-659N74USTwo Three Air LLC · Orlando, FLBuilt 1974 · S/N E-574N74WJVicari Aviation LLC · Harvey, LABuilt 1988 · S/N E-2458N74WMTurnage Leon G · Weatherford, TXBuilt 1975 · S/N TH-653N750JFHamontree Gerry · Ellsworth, KSBuilt 1991 · S/N CE-1633N751PPPlane White Corporation · Sunriver, ORBuilt 1999 · S/N E3260N753DMAcid And Cementing Inc · Palestine, TXBuilt 2002 · S/N TH-2047N7542DBeach Bound Baron LLC · Modena, NYBuilt 1971 · S/N TE-843N754PMid Continent Harley Davidson Inc · Wichita, KSBuilt 1973 · S/N E-461N755GHJeff Hux Farms LLC · Sikeston, MOBuilt 1997 · S/N TH-1838N755RTired Iron Aviation LLC · Sheridan, WYBuilt 1980 · S/N EA-85N755TAg Air Ltd · Harwood, NDBuilt 1972 · S/N D-9364N756TN756t LLC · North Royalton, OHBuilt 1972 · S/N D-9369N757AMKhorzad Kaveh · Austin, TXBuilt 1998 · S/N E-3181N757FVintage Aircraft LLC · Leesville, SCFirst renewal noticeS/N E-3121N757PABmr Financial Inc · Kingston Springs, TNBuilt 1982 · S/N TH-1333N758CG Daniel Evans P C · Birmingham, ALBuilt 1981 · S/N TH-1275N758CAAccess Denied Inc · Wilmington, DEBuilt 1978 · S/N TH-1001N758PBas Part Sales LLC · Greeley, COBuilt 1999 · S/N TH-1907N758WPAcr Aircraft LLC · Dover, DEBuilt 1975 · S/N TH-666N759VLBarto Jerrel · Kula, HIS/N E-1164N75AMAirjohn LLC · Cheyenne, WYBuilt 1974 · S/N TE-1019N75ATGta Air Inc · Addison, TXBuilt 1974 · S/N E-597N75BKN75bk LLC · Midland, TXBuilt 1990 · S/N CE-1524N75CLClear LLC · Pierre, SDBuilt 1977 · S/N TH-878N75CSWeskap Hangar Management LLC · West Grove, PAS/N CE-949N75HPN5949s LLC · Hereford, TXBuilt 1984 · S/N EA-415N75RMDodson International Parts Inc · Rantoul, KSS/N EA-402N761LTFiddelman Joseph D · Port Orange, FLBuilt 1978 · S/N D-10187N762TFair Skies LLC · East Meadow, NYBuilt 1973 · S/N D-9434N76498Doucey Mark R · The Villages, FLS/N E2607N764DHHess David G Trustee · Chandler, AZS/N CE-1072N764TSullivan Jerald S · Gilbert, AZBuilt 1973 · S/N E-392
Back to AD 87-18-06 R1