AD 2022-09-13

Registered aircraft · 172

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-09-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-09-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.

N26RDPacific North Air LLC · Portland, ORS/N 34-7350167N277AMParis Air Inc · Vero Beach, FLBuilt 1974 · S/N 34-7450188N2824TEscudier Henry · Houston, TXBuilt 1972 · S/N 34-7250171N2871TCloud Dancer Aviation Inc · Deland, FLBuilt 1972 · S/N 34-7250178N2882TParis Air Inc · Vero Beach, FLBuilt 1972 · S/N 34-7250180N28BMUS Flight Academy Intl Inc DBA · Post, TXBuilt 1973 · S/N 34-7350149N300DESchmidt Arthur J · Tampa, FLS/N 34-7770157N302EFRedbird Ventures LLC · Kalispell, MTS/N 34-7350328N303RCYogini Modi · Homestead, FLBuilt 1971 · S/N 34-7250016N3097TD & L Aircraft Leasing LLC · Ormond Beach, FLBuilt 1972 · S/N 34-7250343N30FHBaldwin Jonathan B · East Boothbay, MEBuilt 1973 · S/N 34-7350203N333BBDenecke Robert W · Fredericksburg, VAS/N 34-7250279N333SEParis Air Inc · Vero Beach, FLBuilt 1973 · S/N 34-7350091N341TCRegistration Pending · Wilmington, DERegistration pendingBuilt 1974 · S/N 34-7450161N34201Talon Air LLC · Newport, KYS/N 34-7450185N342GRSouthern Aero LLC · Homestead, FLBuilt 1972 · S/N 34-7250021N344MCEuroaviation Inc · KematenBuilt 1973 · S/N 34-7450008N34ESTough Old Bird Aviation LLC · Beavercreek, OHBuilt 1973 · S/N 34-7450078N34MYParis Air Inc · Vero Beach, FLS/N 34-7450088N37SACampbell John R Trustee · Saint Leo, FLBuilt 1972 · S/N 34-7250046N401DSDelaware State University · Dover, DEBuilt 1972 · S/N 34-7250156N4063GHorizon Flights Corp · Henderson, NVNon-citizen corporation, flight hours not reportedBuilt 1972 · S/N 34-7250069N40785Plane Fun Inc Tr Trustee · Snellville, GABuilt 1973 · S/N 34-7450079N40982Seneca Aviation LLC · Wheaton, MDBuilt 1974 · S/N 34-7450095N411SVCc Aviation Inc · Tracy, CABuilt 1972 · S/N 347250348N41249Sale Reported · Nephi, UTSale reportedBuilt 1974 · S/N 34-7450102N41285Paris Air Inc · Vero Beach, FLBuilt 1974 · S/N 34-7450105N41502Skymates Inc · Wilmington, DEBuilt 1974 · S/N 34-7450125N41538Sunrise Aviation Inc · Ormond Beach, FLBuilt 1974 · S/N 34-7450131N41960Tiffin Aviation Services Inc · Nogales, AZBuilt 1974 · S/N 34-7450165N424WTLumberton Air 1 LLC · Mount Laurel, NJBuilt 1973 · S/N 34-7350142N428663 Elm Terrace LLC · Waterville, MEBuilt 1974 · S/N 34-7450173N43034A S Flight Academy LLC · Lantana, FLBuilt 1974 · S/N 34-7450175N43130University Of Maryland Eastern Shore · Princess Anne, MDBuilt 1974 · S/N 34-7450180N43134Minot Aero Center · Minot, NDS/N 34-7450150N43394Skyline Solutions Inc · Deland, FLS/N 34-7450186N43519Paris Air Inc · Vero Beach, FLS/N 34-7450192N43577Novaair LLC · Lake Sherwood, CABuilt 1974 · S/N 34-7450194N43690Fly Twin Commanche LLC · Peoria, AZBuilt 1974 · S/N 34-7450198N439PTKnot Mach LLC · Mchenry, ILBuilt 1974 · S/N 34-7450179N44332International Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 34-7450068N44416Registration Pending · Punta Gorda, FLRegistration pendingBuilt 1974 · S/N 34-7450209N444SAPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250183N4475TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250106N4481TValdes Eusebio · Miami, FLS/N 34-7250108N4534TSunrise Aviation Inc · Ormond Beach, FLBuilt 1972 · S/N 34-7250127N4542TFlight Leasing Corp · Wilmington, DEBuilt 1972 · S/N 34-7250128N455LPhoenix East Aviation LLC · Daytona Beach, FLS/N 34-7450172N4567TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250136N4574TBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 34-7250137
Back to AD 2022-09-13