OpenAirDocs.org
AD 2022-08-13

Registered aircraft · 3,067

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

N1005VGb Spraying LLC · Bridgeport, NEBuilt 1988 · S/N 402-0694N10078Dallas Aero & Sales LLC · Poplar, MTBuilt 2013 · S/N 502B-2881N1008FMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 1988 · S/N 502-0033N1009FDavidson Richard E · Tchula, MSBuilt 2019 · S/N T34-484N100AMBoundless Blue LLC · Scottsdale, AZBuilt 2018 · S/N 100-0259N100JFIsr Aviation LLC · Wilmington, DEBuilt 2005 · S/N 123N100KLRobert Wiplinger N100kl LLC · South Saint Paul, MNBuilt 1955 · S/N 758 (1483)N100KNRak Kodiak LLC · Middletown, DEBuilt 2018 · S/N 100-0257N10129Parrish Aerial Services LLC · Wilmington, DEBuilt 1989 · S/N 502-0051N1012BMidwest Aerial Applicators LLC · Whittington, ILBuilt 1989 · S/N 402-0712N1012ZBuffalo Aviation LLC · Monette, ARBuilt 1989 · S/N 502-0044N1014LSale Reported · Walnut, ILSale reported, pending cancellationBuilt 1989 · S/N 401A-0733N1017XAaa Aviation LLC · Donalsonville, GABuilt 1989 · S/N 402-0734N10185Oli Grow LLC · Baskin, LABuilt 1989 · S/N 502-0063N10189Whalen Mark P · Millington, MDBuilt 1989 · S/N 402A-0738N1019SBuffalo Ridge Airspray LLC · Milbank, SDS/N 502-0066N101AKPacific Diversified Investments Inc · Anchorage, AKBuilt 2025 · S/N 100-0356N101KQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 100-0101N101TAHatch Hyrum G · Gilbert, AZBuilt 1977 · S/N 421C0331N101XWJoby Aero Inc · Santa Cruz, CABuilt 1993 · S/N 208B0382N1021BBeachy Flying Service LLC · Whittington, ILBuilt 1989 · S/N 502-0062N1026VPa1 208b-0319 LLC · Fort Lauderdale, FLBuilt 1992 · S/N 208B0319N102DBFinch Air LLC · Midland, TXBuilt 1996 · S/N BB1537N102KQAogline.Com Inc · Fullerton, CAS/N 100-0102N1031PMartinaire Aviation LLC · Addison, TXBuilt 1994 · S/N 208B0404N1037NMartinaire Aviation LLC · Addison, TXBuilt 1993 · S/N 208B0334N103ANCessna 208b0928 Inc Trustee · Wilmington, DEBuilt 2001 · S/N 208B0928N103CWFlying Pigs LLC · Kinston, NCBuilt 1985 · S/N FA64N103LALove Aero LLC · Leland, MSBuilt 2001 · S/N 402A-1133N1041LMartinaire Aviation LLC · Addison, TXBuilt 1993 · S/N 208B0337N104WYWyoming Department Of Transportation · Cheyenne, WYBuilt 2004 · S/N 20800377N1056BCorral Ventures LLC · Atlantic Beach, FLBuilt 2003 · S/N 499N1058NAvion Capital Corp · Anchorage, AKBuilt 1993 · S/N 208B0347N105EV2nd Amendment Wholesale Inc · Grand Forks, NDS/N UE-64N105JFIsr Aviation LLC · Wilmington, DEBuilt 1997 · S/N 20800272N105SLSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 2003 · S/N 1068N105VEPlane Fun Inc Tr Trustee · Snellville, GABuilt 1998 · S/N 208B0680N1068KGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1448N106LAVisser Ag Inc · Rigby, IDBuilt 2001 · S/N 802A-0106N106RFRandigo LLC · Wilmington, DEBuilt 1995 · S/N 208B0481N106VERedding Aero Enterprises Inc · Redding, CABuilt 1999 · S/N 208B0769N1076KGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1461N1079DGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1462N1079UTurbines Ltd · West Point, NEBuilt 1980 · S/N 31122N107CANorth Applicair Corp · Panama City Beach, FLBuilt 1988 · S/N R1340011N107KAN107ka Inc · Addison, TXBuilt 2005 · S/N 208B1107N107KQJsc Rentals LLC · Missoula, MTBuilt 2014 · S/N 100-0107N107MLMike Ogan Farms · Pierre, SDBuilt 2012 · S/N 402B-1250N1086FAvion Capital Corp · Anchorage, AKBuilt 1995 · S/N 208B0436N108RFRandigo LLC · Wilmington, DEBuilt 1996 · S/N 208B0528
Back to AD 2022-08-13