OpenAirDocs.org
AD 81-24-07

Registered aircraft · 1,930

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:81-24-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:81-24-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.

N1003QKing Jeffrey J · Fort Worth, TXS/N 32R-7780217N100AESale Reported · Spencer, NESale reported, pending cancellationBuilt 1978 · S/N 32R-7985058N100JGClub Cherokee Inc · Crystal, MNBuilt 1988 · S/N 3213019N100NAInternational Air Services Inc Trustee · Carson City, NVS/N 32R-8013093N100VFMeridian Aviation N100vf LLC · Mobile, ALBuilt 1977 · S/N 32R-7780539N101CEDurocher Alain P · Long Beach, CABuilt 1982 · S/N 32R-8229066N101DRShaheen Louis · Austin, TXBuilt 1978 · S/N 32R-7885181N101DWInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 32R-7680399N101NMHarris Group LLC · Springfield, VAS/N 32R7985099N101TKLensing Wayne K · Popular Grove, ILBuilt 1980 · S/N 32R-8029062N101WCole-Tac LLC · Rapid City, SDBuilt 1980 · S/N 32R-8013087N101WCRamey Curtis · Hilton Head Island, SCBuilt 1976 · S/N 32R-7680381N102EASteves Atv Services Inc · Oceano, CABuilt 1976 · S/N 32R-7680158N1030NDcaw Aviation LLC · Advance, NCBuilt 2006 · S/N 3246242N103EAJwp Group LLC · Long Island, MEBuilt 1976 · S/N 32R7780054N1040HKing Jay M · Kokomo, INBuilt 1976 · S/N 32R-7780124N1041HCentury Flight Systems Inc · Mineral Wells, TXBuilt 1977 · S/N 32R-7780125N104GKIndigo Bunting Aviation LLC · Morristown, NJBuilt 1977 · S/N 32R7780461N1057HFrese Albert · Creede, COS/N 32R-7780127N105HPRyan Transportation Services Ltd · Marysville, OHBuilt 2003 · S/N 3257322N1063CJim Johnson Nissan Inc · Bowling Green, KYBuilt 2006 · S/N 3257440N1063HWalker Db · Rougemont, NCS/N 32R-7780129N1063QRussell Construction Co · Douglas, WYBuilt 1977 · S/N 32R-7780221N1066BWexhler David R Trustee · Carlsbad, CABuilt 2006 · S/N 3257443N1066ERising Skies LLC · Carefree, AZBuilt 2006 · S/N 3246244N1066SOmll Investments LLC · Ponte Vedra Beach, FLBuilt 2007 · S/N 3257457N106ATLichtman Aaron Marcus · Baltimore, MDS/N 32R-7780326N106LValiair Lc Trustee · Casper, WYBuilt 2000 · S/N 3257130N108NSLyon Andrew L · Fairbanks, AKBuilt 1976 · S/N 32R-7680288N109MBFirefly Aviation LLC · Midland, TXBuilt 1978 · S/N 32R-7887238N10JKZalan Aviation LLC · Cincinnati, OHBuilt 1978 · S/N 32R-7887242N10ZVThat 70s Plane Inc · Athens, GABuilt 1977 · S/N 32R-7780390N110WRRuffo-Silva LLC · Wilmington, DEBuilt 1978 · S/N 32R-7985056N1111MRw Air LLC · Rock Hill, SCBuilt 1982 · S/N 32R-8329010N111NWKnell LLC · Casper, WYBuilt 1976 · S/N 32R7680499N111RWNordo LLC · Kettering, OHS/N 32R-8129064N111SNHalbert Kevin · Tyler, TXBuilt 1977 · S/N 32R-7880040N1122EVasey Igor · San Francisco, CABuilt 2000 · S/N 32-57176N1134QFalyers Inc · Prairie Du Chien, WIS/N 32R-7780224N1139LMathewson Crews Aviation LLC · Indianapolis, INBuilt 1980 · S/N 32R8029091N113TRBell Thomas E · Henniker, NHBuilt 1976 · S/N 32R-7680207N1147HSpacious Skies LLC · Overland Park, KSBuilt 1977 · S/N 32R-7780139N115CSBurger Aviation LLC · Brandon, MSBuilt 2000 · S/N 32-46177N115HPCam Aviation LLC · Valparaiso, INBuilt 1998 · S/N 3246115N1177AN1177a LLC · Lewes, DEBuilt 1977 · S/N 32R-7780430N117CSSam Airlines LLC · Wilmington, DEBuilt 1996 · S/N 32-46024N117GHAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N 3257217N118ESCmv Aviation LLC · Johnson City, NYBuilt 1976 · S/N 32R-7680374N1198HAlge Aviation · Middletown, DES/N 32R-7780143N119GSDall James R Jr · Hayes, VABuilt 1985 · S/N 32R-8529009
Back to AD 81-24-07