AD 2017-20-08
Registered aircraft · 1,569
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:2017-20-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-20-08')
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:2017-20-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-20-08') 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.
N119JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN11ARPerpetual Air LLC · Arlington, VAN11FTBank Of Utah Trustee · Salt Lake City, UTN11GW1010 Aviation LLC · Stuart, FLN11PHPegasus Wings LLC · Santa Monica, CAN1202CScarlet Capital LLC · San Francisco, CAN120JJAviation Sales Associates LLC · Costa Mesa, CAN120LWN120lw LLC · New York, NYN120SBHrs Aircraft LLC · New York, NYN120WJFly Vulture Aviation LLC · Southwest Ranches, FLN121APCrossland Global Sky LLC · Rogers, ARN121EFEf Falcon LLC · Hobe Sound, FLN1221GN1221g LLC · Fort Worth, TXN1222POggv LLC · Houston, TXN123FTMirada Manager Gv LLC · Denver, CON125GGSk Aviation Asset I LLC · Miami, FLN125GHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN126EBElainebrown LLC · Anchorage, AKN126HRSeminole Tribe Of Florida · Hollywood, FLN1271MGlobal Destinations LLC · Beaumont, TXN127CRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN127RRPhiladelphia Church Of God Inc · Edmond, OKN129NSHarvey Horses LLC · Wilmington, DEN12NUFlexjet LLC · Cleveland, OHN130GVBank Of Utah Trustee · Salt Lake City, UTN130JEReserve Jets Acquisitions LLC · New York, NYN131JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN132JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN132SD342 Ktcd LLC · Austin, TXN133RCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN136FXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN137WSCf Aviation Trust LLC Trustee · Wilmington, DEN13999Zeit2019 LLC · Salt Lake City, UTN13JHoldacacha Management LLC · Raleigh, NCN13SAAvire LLC · Los Angeles, CAN1415NWilmington Trust Co Trustee · Wilmington, DEN141JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN142HQMax Aircraft LLC · Moon Township, PAN143Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN143LPPachy Music Corporation · Bellflower, CAN144ABFly Evolution LLC · La Puente, CAN144PKAvire LLC · West Hollywood, CAN1454HTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN1459AG1459 Leasing LLC · Fort Lauderdale, FLN145MGJlbml LLC · Atlanta, GAN145RTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN1461Bank Of Utah Trustee · Salt Lake City, UTN1461XBank Of Utah Trustee · Salt Lake City, UTN146BGAircraft Holdings Inc · Fort Lauderdale, FLN14717Csc Delaware Trust Co Trustee · Wilmington, DE
Back to AD 2017-20-08