OpenAirDocs.org
AD 77-09-10

Registered aircraft · 2,918

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:77-09-10')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-09-10')
  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.

N1008NK W Racing LLC · Angola, INBuilt 1973 · S/N 27-7305152N100BSC & C Logging LLC · Kelso, WABuilt 1966 · S/N 27-3431N100CNAileron Aviation Inc · Sparta, TNS/N 27-7754050N100EMKentem100 LLC · Asheboro, NCBuilt 1981 · S/N 31-8152196N100LYLyon Aviation Inc · Pittsfield, MAS/N 31-8052064N100POut Island Magic LLC · Gainesville, FLBuilt 1982 · S/N 31-8252019N100XRTomsis Corp · Panama City, FLBuilt 1981 · S/N 31-8152169N100YGAnderton Doyle M · Royse City, TXS/N 31P-7530010N1018TLeon J Hapka · Halma, MNS/N 24-4884N101HHElmhurst Holdings LLC · East Rochester, NYBuilt 1980 · S/N 27-8054057N101MAPablo Air Charters LLC · New Freedom, PABuilt 1977 · S/N 31-7752186N101NWVortex Aircrafts Inc · Port Saint Lucie, FLBuilt 1961 · S/N 27-475N101PLHay William G Jr · Gualala, CAS/N 27-7754156N1020HHw Barnhouse Inc · Vero Beach, FLBuilt 1968 · S/N 30-1569N102WHStuddiford James A · Lithia, FLS/N 31-7952066N102WMStar Air Service LLC · Jacksonville, FLBuilt 1981 · S/N 31-8152112N1033TManzo Deborah S · Lake Placid, FLBuilt 1973 · S/N 27-7405302N1036LN1036l Corp · Wilmington, DEBuilt 1976 · S/N 27-7654135N103BUColorado Aircraft Corp · Watkins, COS/N 31-7405202N103HPMcfarland Natalie · Roseburg, ORBuilt 1965 · S/N 24-4153N103PGHnd Operations LLC · Henderson, NVBuilt 1969 · S/N 30-1858N104CPN7293l LLC · Waxahachie, TXBuilt 1966 · S/N 30-1276N104MQL C Whitford Co Inc · Wellsville, NYBuilt 1979 · S/N 31-7952210N105CHMach Tuck LLC · Daytona Beach, FLBuilt 1974 · S/N 27-7405419N106JLMusic City Air LLC · Rogersville, ALBuilt 1963 · S/N 27-2416N106REColorado Aircraft Corp · Watkins, COS/N 31-7752056N1071AOcean Group LLC · Plantation, FLBuilt 1979 · S/N 31-7952195N107PAPacific Fleet Aviation LLC · Rochester, NYS/N 27-7854002N10816Van Der Merwe Coenraad · Traverse City, MIBuilt 1968 · S/N 244753N10853St Johns Marine DBA · San Mateo, FLS/N 277854024N108BHEmt Bahamas Holdings LLC · Greer, SCS/N 31-214N108JLStar Marianas Aviation School Inc · Saipan, MPBuilt 1983 · S/N 31-8352028N109CCTrans-Caribbean Air Exp & Imp Inc · Miami, FLBuilt 1968 · S/N 27-4024N10MAPatterson Casey Paul · Kinston, ALS/N 24-4180N10YDDavenport Jimmy J · Hayesville, NCBuilt 1965 · S/N 27-2892N1100LRaider Aviation LLC · Lubbock, TXS/N 30-12N110LLFlight Level 7 Inc · Wilmington, DEBuilt 1971 · S/N 39-89N110WWTorba Jacob · Citrus Heights, CABuilt 1969 · S/N 30-1846N1111HBielamowicz John Kolbe · Waxahachie, TXBuilt 1964 · S/N 30-427N111CFGsm Tax & Insurance Inc · Naples, FLBuilt 1976 · S/N 31-7652105N111DLCresence LLC · Port Saint Lucie, FLBuilt 1976 · S/N 27-7654167N111EWimpy Scott · Griffin, GAS/N 24-4210N111GAGeorges Aviation Services Inc · Honolulu, HIBuilt 1981 · S/N 31-8152050N111MYMeshed Networx LLC · New Market, VABuilt 1978 · S/N 27-7854092N111PLColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1969 · S/N 301929N111SEKeith Fischer · Gig Harbor, WABuilt 1966 · S/N 24-4462N111UCRcht LLC · Mason, OHBuilt 1979 · S/N 31-7952190N113JBMcdonald Aviation Inc · Knoxville, TNBuilt 1960 · S/N 27-226N1147N7371y LLC · Waterford, MIBuilt 1964 · S/N 30-423N114CDNorwest Ventures LLC · Santa Cruz, CABuilt 1963 · S/N 30-37
Back to AD 77-09-10