AD 87-20-03 R2
Registered aircraft · 54,015
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-20-03-R2')
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-20-03-R2')
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-20-03-R2') 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-20-03-R2') 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.
N88EStarlite Aviation Technologies LLC · Las Vegas, NVN88GMField Drew H · Dallas, TXN88HQAviation Capital Management LLC · San Jose, CAN88HSShields Edwin G · York, SCN88JDRichardson H L · Reform, ALN88KMTsukii Toshikazu · Tucson, AZN88KNRegistration Pending · Santa Rosa, CARegistration pendingN88KWDonnell James C · Crowville, LAN88MALowry Michael L · Chesterton, INN88MLProstar Flight Services LLC · Bozeman, MTN88NGBakke Dale W · Yankton, SDN88PBBraswell Jerrold W · Dillingham, AKN88PKGray Farms Inc · Albany, ORN88RBWarner David J · Englewood, OHN88RKJkg LLC · Idaho Falls, IDN88SYYamashita Bruce · Honolulu, HIN88TNErwa Mohamed · Lago Vista, TXN88YWCharlston Michael M · Haleiwa, HIN8900BMathews Denis W · Quanah, TXN8900TSkyote LLC · Boise, IDN8901BThompson Douglas P Trustee · Alton Bay, NHN8901XHilde Justin · Statesboro, GAN89021Tevik Michael A · Provo, UTN8902BLeonard William L · Gettysburg, PAN8902TShort Steven A · Neillsville, WIN8902VFlycarolina LLC · Concord, NCN89038Gross Matthew D · Saint Paul, MNFirst renewal noticeN8903XGreene Bruce · Asheville, NCN8904VWaymaker Aviation LLC · Yukon, OKN8904XPlanes Of Fame Air Museum · Chino, CAN89054Stcup 152 LLC · Chicago, ILN89055Hageman George · Pebble Beach, CAN8905BGamble Dennis H · Cottonwood, ALN8906SHoskins Brent E · Caldwell, IDN8906TTln Aviation LLC · Stanwood, WAN8906VLewis David A · Broadalbin, NYN89071Pavco Inc · Gig Harbor, WAN89073O Reilly Thomas P · Oscoda, MIN8907BRaven Aviation LLC · Lexington, KYN8907GInfinity Aviation · Pine Island, MNN8907QBurks Excavation Corp · Hailey, IDN8907VSmith Melvin Roy · Gulf Breeze, FLN8907XFrey Harlan Jerome · Carey, OHN8908BAxmacher Mark A · Hillsboro, OHN8908TWinit Matthew C · Woodland, WAN89090Huggins Elissa D · El Paso, TXN89098Dobbelaere Craig · Oakwood, OHN8909TFinley Steven V · Fort Collins, CON8909XHubbert Stephen B · Owasso, OKN890PGCp Air LLC · Indianapolis, IN
Back to AD 87-20-03 R2