OpenAirDocs.org
AD 78-22-07

Registered aircraft · 404

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:78-22-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:78-22-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.

N100AESale Reported · Spencer, NESale reported, pending cancellationBuilt 1978 · S/N 32R-7985058N101DRShaheen Louis · Austin, TXBuilt 1978 · S/N 32R-7885181N101NMHarris Group LLC · Springfield, VAS/N 32R7985099N109MBFirefly Aviation LLC · Midland, TXBuilt 1978 · S/N 32R-7887238N10JKZalan Aviation LLC · Cincinnati, OHBuilt 1978 · S/N 32R-7887242N110WRRuffo-Silva LLC · Wilmington, DEBuilt 1978 · S/N 32R-7985056N12347Butler Construction Services LLC · Oak Grove, MOS/N 32RT-7885055N127VGEvans James F · Columbus, GABuilt 1978 · S/N 32R-7885274N130KSouthern Aircraft Consultancy Inc Trustee · NorfolkRegistration ineffective or invalidBuilt 1978 · S/N 32R-7885109N130XRM&A Adams Family Lp · Mckinney, TXS/N 32R-7887003N132CHSimon Aviation LLC · Bourg, LABuilt 1978 · S/N 32R-7887060N134CHTeke Elevate LLC · San Antonio, TXBuilt 1978 · S/N 32R-7887138N144EZFlorida Aviation LLC · Tallahassee, FLS/N 32R-7885184N14DWBurnett Timothy S · Birmingham, ALS/N 32R-7887023N1636PCorsnitz Bryan Scott · Huntington Beach, CABuilt 1978 · S/N 32R-7887228N1640PBucher Max · Fort Mohave, AZBuilt 1978 · S/N 32R-7887221N165RTxav8r LLC · Houston, TXBuilt 1977 · S/N 32R7885217N169BWFarris Frederick J · Sandpoint, IDBuilt 1978 · S/N 32R-7885080N16BJMarshall John Robert · Missouri City, TXBuilt 1979 · S/N 32R-7987115N1701EValiair Limited Co Trustee · Casper, WYBuilt 1978 · S/N 32R-7885002N171GStockwell Donald C · Westport, MABuilt 1978 · S/N 32R-7885241N177CMRapid Cloud Aviation LLC · Waxhaw, NCBuilt 1978 · S/N 32R-7887273N187GJerchau Ryan P · Bellmore, NYBuilt 1978 · S/N 32R-7887235N188SEChernov Boris · Lima, OHBuilt 1978 · S/N 32R-7885255N191RVSpurgeon Michael · Nashville, TNBuilt 1978 · S/N 32R-7887051N19PEN19pe LLC · Stone Mountain, GABuilt 1978 · S/N 32R-7885068N200MABas Part Sales LLC · Greeley, COBuilt 1978 · S/N 32R-7887266N200SFRes Solutions Inc · Anderson, INBuilt 1978 · S/N 32R-7985034N2078BD & P Jones Enterprises Inc · Santa Cruz, CABuilt 1979 · S/N 32R-7987022N2079XDe Flyers LLC · Vicksburg, MIBuilt 1979 · S/N 32R-7987120N20817Beard Russell G · Goodyear, AZBuilt 1978 · S/N 32R-7887179N2081AKing David M · Ormond Beach, FLBuilt 1978 · S/N 32R-7885283N2087ASmith Morris A · Odessa, TXBuilt 1978 · S/N 32R-7987001N20885Herzberg Johnny R · Sparks, NVS/N 32R-7885247N20928Shelley Aaron J · Corbin, KYBuilt 1978 · S/N 32R-7887182N2093CJerles William R Jr · Roberta, GABuilt 1978 · S/N 32R-7985022N2094PCampbell John A · Brentwood, TNBuilt 1979 · S/N 32R-7985077N2096ABlack River Water & Air LLC · Poplar Bluff, MOBuilt 1978 · S/N 32R-7985001N2100AAniakudo Obiesili · Northville, MIS/N 32R-7987002N21018Vega Aircraft LLC · Arcadia, OKBuilt 1978 · S/N 32R-7887186N2101FVaughan Bradley C · Truckee, CABuilt 1978 · S/N 32R-7987064N21027Noomen Excavating LLC · Currie, MNBuilt 1978 · S/N 32R-7887187N2102BGillen Diesel Aviation LLC · Dania Beach, FLBuilt 1978 · S/N 32R-7985011N2102SJericho Air LLC · Hilton Head Island, SCBuilt 1979 · S/N 32R-7985085N2105BNwf Aviation LLC · Defuniak Springs, FLBuilt 1979 · S/N 32R-7987025N2111ARoth David · Corrales, NMBuilt 1978 · S/N 32R-7987004N2115BMisner Gear K · Phoenix, AZBuilt 1979 · S/N 32R-7987026N2117HEarl Nathan E · Noblesville, INBuilt 1978 · S/N 32R-7985045N2120BAec Air LLC · Springfield, MOS/N 32R-7987027N2122GDavid Mieding Trustee · Reno, NVBuilt 1978 · S/N 32R-7985055
Back to AD 78-22-07