OpenAirDocs.org
AD 2023-08-07

Registered aircraft · 476

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:2023-08-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:2023-08-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.

N100FMajor Kens Flying Service LLC · Colfax, NDBuilt 1972 · S/N 1021N10286Flying D Farm Inc · Kerhonkson, NYBuilt 1961 · S/N 86N118JDJacobson Luke W · Reno, NVS/N 863N127FCBurghduff Aviation LLC · Ludlow, SDS/N 1393N135VAWallace Aviation Inc · Wallace, NEBuilt 1976 · S/N 27BN164APElwood Farms Inc · Levelland, TXBuilt 1977 · S/N 1706N164TAThompson Aero Inc · Amana, IABuilt 1980 · S/N 651BN164TNBuntings Dusting Inc · Berlin, MDBuilt 1978 · S/N 412BN16AAMcpherson Timothy L · Page, NDBuilt 1971 · S/N 792N211ERMorgans Flying Service LLC · Morse, LABuilt 1977 · S/N 254BN211JMSanderson Grain Inc · Springlake, TXBuilt 1976 · S/N 69BN2236FWells Nathan S · Scotia, NEBuilt 1988 · S/N 807BN2437DMcclung Aerial Spraying Inc · Big Springs, NES/N 764BN2500WBasin Aviation Inc · Rio Oso, CABuilt 1982 · S/N 704BN27SKKingsley Kiman J · Miller, MOBuilt 1974 · S/N 1341N29GWRegistration Pending · Tyler, MNRegistration pendingBuilt 1975 · S/N 1564N2LUMowata Farms LLC · Mamou, LAS/N 595BN31GWHershey Flying Service Inc · David City, NES/N 507BN32RAZumwalt Aviation LLC · Sheldon, ILBuilt 1976 · S/N 31BN342KGAviation Services Of Grady County Inc · Pelham, GABuilt 1977 · S/N 263BN34TFAlbertson James M · Slocomb, ALS/N 1724N36265Sutter Butte Dusters Inc · Live Oak, CABuilt 1983 · S/N 725 BN36269Mcclung Aerial Spraying Inc · Big Springs, NEBuilt 1983 · S/N 726 BN3626GSky Tractor LLC · Hillsboro, NDS/N 718BN36270Gilland Jonathan R · Elkton, TNS/N 734BN3627BAir Enterprises LLC · Dover, DES/N 727 BN3627GBuntings Dusting Inc · Berlin, MDBuilt 1983 · S/N 729 BN3627QSutter Butte Dusters Inc · Live Oak, CABuilt 1983 · S/N 730 BN3627SJackieson LLC · Kaplan, LAS/N 732BN3628TMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1984 · S/N 737BN3628ZMcclung Aerial Spraying · Big Springs, NEBuilt 1984 · S/N 738BN3629DWallace Aviation Inc · Wallace, NEBuilt 1984 · S/N 743BN3629JVincent Flying Service Inc · Kaplan, LABuilt 1984 · S/N 747BN3629KScott Flying Service Inc · Bono, ARBuilt 1984 · S/N 748BN3629NWatson Air Farm LLC · Donaldsonville, LAS/N 749BN36303Raider Aviation LLC · Southampton, NJBuilt 1984 · S/N 761BN3630BWallace Aviation Inc · Wallace, NEBuilt 1984 · S/N 755BN3630UCajun Cats LLC · Kaplan, LAS/N 760BN3632TMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1985 · S/N 772BN36333Sky Tractor LLC · Hillsboro, NDBuilt 1986 · S/N 785BN3633CCw Equipment Rentals Inc · Biggs, CAS/N 776BN3633SKingrey William Sampson III · Richmond, TXBuilt 1986 · S/N 778BN3633TAerial Control Inc · Brentwood, CABuilt 1986 · S/N 779BN410XBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 631N41844Todd Greggory S · Ankeny, IAS/N 385BN4241Ham Orlando DBA · Opdyke, ILBuilt 1972 · S/N 1011N4244Kingsley Kiman J · Miller, MOBuilt 1973 · S/N 1034N425LSRed Willow Rescue Inc · Cooperstown, NDS/N 598BN4369Lewis Flying & Maint Svc Inc · Morse, LABuilt 1973 · S/N 1045N43875Cascade Airways LLC · Corvallis, ORS/N 766B
Back to AD 2023-08-07