AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
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:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') 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.
N738SYVan Anda Aviation LLC · Apopka, FLN738TBSorbi Aviation Inc · El Cajon, CAN738TFFly Vector LLC · Spring Hill, FLN738TGWings Aero LLC · Zeeland, MIN738TJGlendale Community College · Glendale, CAN738TMBrown Clifford · League City, TXN738TNBarnett Mary C · Upland, CAN738TPLacey Christopher · Cape Coral, FLN738TQLake Travis Flyers LLC · Granite Shoals, TXN738TTRfc Inc · Hiawatha, IAN738TVGordon Benny B · Columbia City, INFirst renewal noticeN738TXLavalley Asset Management Inc · Potsdam, NYN738TYForest Structural Engineering Inc · Boston, MAN738TZRegistration Pending · Fort Worth, TXRegistration pendingN738UDAffection Above Aviation Inc · Yukon, OKN738UESteinkamp Loren L · Fairmont, MNN738UHSale Reported · Calabasas, CASale reportedN738URCooper William J Jr · Littleton, NCN738UTWright Flyer LLC · Palm Coast, FLN738UUCiuccio Louis V · Old Forge, PAN738UWAircraft Management Services Inc · Milton, FLN738UYOptima Aviation LLC DBA · Lewisville, TXN738VAFive Rivers Flight Training LLC · Livermore, CAN738VBBrafa Frank T · Leesville, LAN738VCMarlin Walter E II · Locust Grove, GAN738VGTepper Steven · Freehold, NJN738VJCommand-Aire LLC · Seattle, WAN738VLBasler Leon E · Sainte Genevieve, MON738VRWoodward Tyler James · Norman, OKN738VTStrutin Millard Desmond · Hackettstown, NJN738VUFive Rivers Flight Training LLC · Livermore, CAN738VVPureflight Aviation Training LLC · Newberg, ORN738VWAwnf LLC · Burleson, TXN738VYRpm Aero LLC · Lincolnwood, ILN738WCBrb Grand-Air LLC · Indiantown, FLN738WEBray Aviation LLC · Calera, OKN738WGZlock David · Lakeville, MNN738WHPiraino Philip A · Middletown, DEN738WJSpann Leonard D · Little Rock, ARN738WKMallette Christopher Lee · Saint Rose, LAN738WLBrenair Inc · Mcalester, OKN738WMMayers Trevor D · Miami, FLN738WNSkywarrior Flight Training LLC · Pensacola, FLN738WRRoberts Dwight C · Seminole, OKN738WVJohnston John A · Raleigh, NCN738WYIsland Aircraft LLC · Anchorage, AKFirst renewal noticeN738WZPitman Steven M · Lyman, SCN738XAHyldburg Aviation · Plymouth, MAN738XCLance Vaculin LLC D/B/A · Murray, UTN738XDMls Aviation LLC · Yorba Linda, CA
Back to AD 87-10-06 R1