AD 75-23-07

Registered aircraft · 827

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

N240RATop Aircraft Leasing LLC · Wilmington, DES/N 310Q0108N240RCIntegrity Sales And Auction LLC · Merrill, WIBuilt 1980 · S/N 310R-1869N240SQMigster LLC · Miami, FLBuilt 1975 · S/N 310R0273N245BMBen-Hur Air Chariots LLC · Fort Myers, FLBuilt 1971 · S/N 310Q0411N24KMNorthern Jet Inc · Iron Mountain, MIS/N 310Q0631N24PMHaven Harmony LLC · Sheridan, WYBuilt 1973 · S/N 310Q0705N252DLPlac Holdings LLC · Paradise, TXBuilt 1975 · S/N 310R0242N254CMGatewood Crisp · Tifton, GABuilt 1975 · S/N 310R0254N257JDAntonini Vittorio · New York, NYBuilt 1970 · S/N 310Q-0071N25LPBer Aviation Inc · Saratoga, CABuilt 1973 · S/N 310Q0748N2631SAsplundh Eric P · Bryn Athyn, PABuilt 1979 · S/N 310R1620N2632BHeubeck Associates Inc · New York, NYBuilt 1979 · S/N 310R1626N2634KKoeppel Steven Lynn Trustee · Mckinney, TXS/N 310R1637N26355Fay Andrew T · San Marcos, TXS/N 310R1645N2635XN2635x LLC · Eau Claire, WIS/N 310R1642N26370Gv Air Inc · Medford, ORBuilt 1979 · S/N 310R1659N2637DMcanulla Robert · Trabuco Canyon, CABuilt 1979 · S/N 310R1655N2638XSoftware 2000 Inc · Arroyo Grande, CABuilt 1979 · S/N 310R1666N2638YLawson Sean E · Lexington, KYS/N 310R1667N2640FLaguna Verde Leasing Inc · Wilmington, DEFirst renewal noticeBuilt 1979 · S/N 310R1676N2641PChandler David G · Phoenix, AZBuilt 1979 · S/N 310R1679N2641ZTfs Air LLC · Loveland, COBuilt 1979 · S/N 310R1804N2642ACronin LLC · Jacksonville, FLBuilt 1979 · S/N 310R1682N2642YStallings Ted W · Seldovia, AKS/N 310R1684N2643YCompany Plane LLC · Wisconsin Rapids, WIS/N 310R1687N2643ZPolizzi Christopher I · Peachtree City, GABuilt 1979 · S/N 310R1688N2644VCrosby David · Potomac, MDBuilt 1979 · S/N 310R1812N2664Lcj Holdings LLC · Youngsville, LAS/N 310R0195N26692Fields Douglas P Jr · Brooklyn, NYBuilt 1979 · S/N 310R1849N2738BSonrise Aviation LLC · Portland, INBuilt 1979 · S/N 310R1828N2740TKraybill Paul D · Portola Valley, CABuilt 1979 · S/N 310R1843N27KCLaperle Brian · Colebrook, NHBuilt 1974 · S/N 310Q1134N28409Gilmore Sherry · Sallisaw, OKS/N 310Q0666N28849Roonie Inc · Wilmington, DES/N 310Q0036N28NTHammock Flying Service Inc · Black Rock, ARBuilt 1975 · S/N 310R0243N2971QOn The Beam Aviation Inc · Hampton, GABuilt 1974 · S/N 310Q1074N2MBAlfa Foxtrot LLC · Statesville, NCBuilt 1978 · S/N 310R1357N2YEAllied Moulded Products Inc · Bryan, OHBuilt 1975 · S/N 310R0577N300BDAircraft Inc · White Bear Lake, MNBuilt 1975 · S/N 310R0258N300EB4031 Pilots LLC · Crown Point, INBuilt 1974 · S/N 310R0082N300EJPartwin LLC · Greenwich, CTBuilt 1974 · S/N 310Q1156N300PM300pm LLC · Bloomington, INBuilt 1978 · S/N 310R1382N301DBDon Davis Aviation Inc · Henderson, KYBuilt 1977 · S/N 310R0891N302MCB & G Ventures LLC · Kalispell, MTBuilt 1973 · S/N 310Q0909N308CFBaba Kenneth D · Sierra Vista, AZBuilt 1973 · S/N 310Q0804N30ETZaldivar Carlos · Miami, FLBuilt 1971 · S/N 310Q0266N30HCKinetic Concepts LLC · Pensacola, FLS/N 310Q1079N30LPDialysis Clinic Inc · Nashville, TNBuilt 1977 · S/N 310R0995N30RWSaltzy Seas LLC · Loxahatchee, FLBuilt 1976 · S/N 310R0667N3101TMission Air LLC · Charlotte, NCS/N 310R1877
Back to AD 75-23-07