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.

N55KMbi · Indn Hbr Bch, FLBuilt 1979 · S/N E-1601N55KCBloch Jeremy · San Francisco, CABuilt 1976 · S/N D-9930N55KJHope For Bethesda · Orange Park, FLBuilt 1977 · S/N TK-40N55KPJm Waypoint LLC · Fresno, CABuilt 1970 · S/N D-9173N55TLRegistered aircraftBuilt 1976 · S/N TE-1079N55TMThomas Kurtis · Lubbock, TXBuilt 1978 · S/N TH-901N55TZBoswell Rick · Bartlesville, OKBuilt 1977 · S/N TE-1115N55VBBregovlieger LLC · West Ossipee, NHBuilt 1975 · S/N TE-1072N55VSSkie Flying Club LLC · Campbell, CAS/N CE-1305N5609SSimply Living LLC · Fort Myers, FLBuilt 1990 · S/N CE-1454N560BBSednal Enterprises · Los Gatos, CABuilt 1994 · S/N EA-562N561Jacobsen John O · Prescott, AZS/N TE-918N5614RLedvina Jay K · Mechanicsburg, PABuilt 1989 · S/N CE-1414N5617CRoot Griffin W · Fayetteville, GABuilt 1990 · S/N CE-1428N5621ZJon Air LLC · Dover, DES/N CE-1463N5628LRegistered aircraftBuilt 1990 · S/N CE-1460N562DTriton Air Solutions LLC · Fenton, MIS/N E-3577N562ELMirman Charles B · Pinehurst, NCBuilt 1970 · S/N D-9174N562YDion William · Coupeville, WABuilt 1991 · S/N E-2633N5634QLegacy Aero LLC · Jonesboro, ARBuilt 1990 · S/N TH-1598N5636GTres Locos Gringos LLC · Lubbock, TXBuilt 1990 · S/N TH-1586N5639ZHowman Aero LLC · Cleveland, OHBuilt 1990 · S/N E-2535N56425Peterson Todd · Cameron Park, CABuilt 1990 · S/N CE-1469N5642WDemski Stanley L III Trustee · Woodbridge, CABuilt 1989 · S/N CE-1419N5643CAdvance LLC · Waterville, MES/N TH-1573N5650LBidzos D James · Reston, VABuilt 1990 · S/N EA505N56539Six 27 Properties LLC · Flint, TXBuilt 1990 · S/N E2539N5655NWiley Aviation LLC · Saint Augustine, FLBuilt 1990 · S/N CE-1464N565MJse Aviation LLC · Franklin, NHBuilt 1990 · S/N E-2525N565PAero Cruz LLC · Agoura Hills, CABuilt 1999 · S/N E-3280N566CCarolina Contrails LLC · Pine Knoll Shores, NCS/N E-3621N5677XKas Properties LLC · Jennings, LABuilt 1993 · S/N E-2797N567EBAlman Inc · Fort Lauderdale, FLBuilt 1979 · S/N E-1543N567MShower Brenden C · Raleigh, NCBuilt 1979 · S/N CE-854N567RMRonald J Mazzolz Inc · San Diego, CAS/N EA-282N567TMLucke & Associates Cpas Lc · Wichita, KSBuilt 1998 · S/N EA-627N567TSTango Sierra LLC · Scottsbluff, NEBuilt 1984 · S/N E-2173N5690ZGold Aviation LLC · Greenville, SCBuilt 1990 · S/N TH-1594N56BKoch & Koch Inc · Grass Valley, CABuilt 1994 · S/N TH-1730N56GLRainosek Kevin · Granbury, TXBuilt 1994 · S/N EA-572N56HMBarrett Keith Alan · Anniston, ALBuilt 1984 · S/N TJ-466N56JLSea Air Inc · Wilmington, DEBuilt 1977 · S/N D-10094N56KMBudake LLC · Macon, GABuilt 1983 · S/N TH-1391N56TLAviation Manpower Solutions Inc · Nashville, TNBuilt 1990 · S/N TH-1597N571DDennis Billy C Jr · Scottsdale, AZBuilt 1975 · S/N TE-1030N571TXTravel Stiffs LLC · Madisonville, KYBuilt 1990 · S/N CE-1522N572BPThomas Andy K · Cary, NCBuilt 1983 · S/N CE-1019N572TMJohnson Eric N · Port Matilda, PABuilt 1984 · S/N E-2125N574HALow Approach LLC · Wilmington, NCBuilt 2001 · S/N TH-1975N574JPThompson Phillip · Lakeway, TXBuilt 1977 · S/N D-10054
Back to AD 87-18-06 R1