AD 2011-01-52
Registered aircraft · 416
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:2011-01-52')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-01-52')
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.
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:2011-01-52') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-01-52') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N71SLSouthern Aircraft Consultancy Inc Trustee · Casper, WYN721CBLung Brian · Williamsburg, OHN721SPSchweizer Rsg LLC · Fort Worth, TXN7233USuttle Joseph S · Moody, ALN725AN725a LLC · Manassas, VAN72LPRavens Rebuilders Inc · Ellenboro, WVN72LTReynolds Cindy L · Wills Point, TXN731TATomlinson Aviation Inc · Ormond Beach, FLN7364HReam Aviation LLC · York, PAN7419FSmith Helicopters Inc · Cotulla, TXN7446FAir Sprayers Inc · Two Buttes, CON7452FReep Nic K · Yakima, WAN7463FWendling Mark A · Bryant, SDN7465FSmith Norman L · Houston, TXN7482FSchweizer Rsg LLC · Fort Worth, TXN7489FColdwell Jerry Lee · Jordan, MTN7490FDodson International Parts Inc · Rantoul, KSN7492FHouston Police Dept · Houston, TXN7493FHouston Police Dept · Houston, TXN74LTDevor Aviation Support Services LLC · Chambersburg, PAN7504SAirczar LLC DBA · Corpus Christi, TXN7504ZMid Pacific Aero Services LLC · Honolulu, HIN7505BSilver Wings Inc Trustee · Wilmington, DEN75068Kinzie Industries Inc · Erie, COExpired dealerN7506NMeshoppen Air LLC · Tunkhannock, PAN75070Mansfield Heliflight Inc · Milton, VTN7507CBlair & Son Inc · Fleetwood, PAN7507MWeststar Ventures LLC · Cannon Falls, MNN7507USierra Sky Aviation LLC · Kalispell, MTN7508HSons Aviation LLC · Moody, ALN7508LBruegger Shannon B · Lance Creek, WYN75105Mitchell Maverick LLC · Mitchell, SDN7511ACouch Construction Co LLC · Palestine, TXN767LHJones Aircraft Co LLC · Cross Plains, TNN771AAJones Aircraft Co LLC · Cross Plains, TNN776LHJones Aircraft Company LLC · Cross Plains, TNN789LHJones Aircraft Company LLC · Cross Plains, TNN801CPMoore Bradley J · Logsden, ORN801SLZadow Ryszard Jerzy · Waller, TXN8045SHenry Mark A · Dickinson, TXN8047LHolmes Frank L · Enterprise, ALN8049PFranklin Ricky L · Glade Hill, VAN8049WTennis Gayland L · Bath, MIN811TTJordison Investments LLC · Auburn, WAN8135LTri County Rentals And Sales Inc · Bell, FLN815SGGierisch Frederick · Utopia, TXN817BWWalker Baylor L · Big Spring, TXN826JWWills John L · Jasper, ALN8363CNelson William J · Citrus Heights, CAN8377FScott Shawn D · Darrington, WA
Back to AD 2011-01-52