AD 98-21-21 R1
Registered aircraft · 85,612
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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.
N2558RKahn Steven P · Boise, IDN2558UDelany Patrick J · Marion, TXN2559LFlying Circus LLC · Bridgeport, WVN2559QJordan Valley Aviation LLC · Jordan Valley, ORN2559USnake River Flying Club LLC · Horseshoe Bend, IDN2559WHighfill Randall W · Hannibal, MON2559XElement Building Solutions Inc · Murphys, CAN2559YA & D Precision Machining Inc · Fremont, CAN255AOld Aircraft Inc · Lake City, FLN255BEkstrum Eric S · Mound House, NVN255BABgp Realty Inc · Boca Raton, FLN255BDInmotion Media Group LLC · Henderson, NVN255CBZions Credit Corp · Salt Lake City, UTN255DHMarina Electric Inc · Cutler Bay, FLN255DSAircraft LLC · Battle Ground, WAN255EM255em LLC · Tampa, FLN255FSSharpline Converting Inc · Wichita, KSN255GCorcoran Frank · Rochelle, ILN255JWDillon William M · Dayton, NVN255KBailey Michael S · Sarasota, FLN255KHSmith Steward Joseph · Reno, NVN255KRAvra Valley Flyers LLC · Gilbert, AZN255MAKmco Inc · Lenexa, KSN255MBPhoenix Aircraft Management LLC · Marathon, FLFirst renewal noticeN255PAAndresen Paul S · Chandler, AZN255RWas Group LLC · Wilmington, DEN255SKParagon Airplane Leasing Co · Fort Myers, FLN255TJVolar II LLC · Edmond, OKN255WFKlapmeier Alan L · Iron River, WIN255WPUnited States Air Force Owner · Hanscom Afb, MAFirst renewal noticeN255XMS-Tee Corp · Mineri Wells, TXN2560GJackson Air LLC · Temecula, CAN2560USpangenberg Daniel M · Greenville, MIN2560VCrowley John Arthur · Visalia, CAN2560WManasseh Medical Imaging Inc · Lubbock, TXN2560XCd Hillcroft Aviation LLC · Superior, CON25612Mad Scientist Aviation LLC · Wilmington, DEN25615Roark Co Inc · Montgomery, ALN2561QMariposa Aviation Inc · East Wenatchee, WAN2561RHeber Valley Flying Club · Park City, UTN2561UNeinast Jeffrey J · Olton, TXN2561WStaker Bryan P · Pleasanton, CAN2561XN343ga Leasing LLC · Anchorage, AKN25622Rutter'S Rudders Lc · Great Falls, MTN25625Martinez Maurice Dominic · La Habra, CAN25627Sutter Jacob O · Roland, ARN25629Plane Nonsense Inc · Middletown, DEN2562DWalker Garrett J · Anchorage, AKN2562LWilkey Paul W · Sullivan, INN2562MPacific Fleet Aviation LLC · Rochester, NY
Back to AD 98-21-21 R1