AD 77-22-01
Registered aircraft · 499
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:77-22-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-22-01')
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:77-22-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-22-01') 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.
N150VECarnes 150ve LLC · Wichita Falls, TXN152WWNardi Greg · Missoula, MTN155LSRainair Avionics Services LLC · Albertville, ALN156GAlliance Air Parts Acquisitions Corp · Oklahoma City, OKN157MHMile Hi Skydivers Inc · Longmont, CON15CTSkydive Grand Haven LLC · Grand Haven, MIN162STState Of Michigan · Lansing, MIN167BBCentral Virginia Aviation Inc · Petersburg, VAN175AZSparrow Group LLC · Cheyenne, WYN176JRKimmel Aviation Insurance Agency Inc · Greenwood, MSN176TWSierra American Corporation · Wilmington, DEN177MKTrans Equipment Svcs Inc · Greenville, SCN17NMCentral Virginia Aviation Inc · Petersburg, VAN1801BSjd Flight LLC · Houston, TXN183SADriscoll David A · Savannah, TNN184BABemidji Aviation Services Inc · Bemidji, MNN187ALAlm Holdings Delaware 2 LLC · Wilmington, DEN188Gear Robert Lee III · Paradise Valley, AZFirst renewal noticeN18MYWorld Aircraft Leasing Inc · Wilmington, DEFirst renewal noticeN190BETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN190EFTriple E Farms LLC · Pasco, WAN190RLCamair Leasing LLC · Granbury, TXN191JRLocke-Lane Aviation LLC · Statesville, NCN197CANighthawk Air Systems Inc · Miami, FLN198KAThompson Benjamin Kyle · Nevada, TXN199DWAeon62 Holdings LLC · Plano, TXN199PLDodson International Parts Inc · Rantoul, KSN1GFFlowers George D · Panama City, FLN1UCBas Part Sales LLC · Greeley, CON2000EBluebird 2000 LLC · Wilmington, DEN200RELw164 Inc Trustee · Wilmington, DEN200RMMps Enterprises LLC · North Platte, NEN2038WYanagida Kazuaki · Norco, CAN203PCEaton Brothers Transportation LLC · Riverside, MON203RDAviation Trust Co LLC Owner Trustee · Oklahoma City, OKN2050ATia Aeronautics Inc · Harlingen, TXN205MSJustice Air Inc · Farmingdale, NYN205STPate & Pate Air LLC · Andalusia, ALN208MLAngelo Sorce Md Pllc · Dandridge, TNN20SA Paradise Repo LLC · Nokomis, FLN20WPMoser Aircraft Service LLC · Huntington, INN210ECState Of Tennessee · Nashville, TNN211CGAzul Air LLC · Dover, DEN214PNavajo Nation · Window Rock, AZN214SCAzul Air LLC · Dover, DEN218PDMoye Robert W · Saint Augustine, FLN2192LSiller Brothers Incorporated · Yuba City, CAN2274LN2274l LLC · Booneville, MSN227DCEllen Vineyards Inc · Sanger, CAN22BBSpillman Robert · Port Orange, FL
Back to AD 77-22-01