AD 98-21-21 R1
Registered aircraft · 85,620
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.
N1710JOpen Skies Aviation LLC · Wellington, KSN1710TGarretson Thomas A · New Smyrna Beach, FLN1711CNorthern Flyway LLC · Anchorage, AKN1711TLeadturn LLC · San Diego, CAN1711VAggravation Aviation Inc · Wilmington, DEN1711WBogaard Jeffery D · Kansas City, MON17123Wieszkowiak Thomas J · Sunbury, PAN1712CGrant Douglas E Jr · Chubbuck, IDN1712DRichter Ty G · Buffalo, SDN1712HColvin Clu D DBA · Big Cabin, OKN1712JTwelvejuliet LLC · Moberly, MON1712TLea Joe A · Mason City, IAN17132Harvey Laurence C · Lincoln, NEN1713GRight Away Trucking Inc · Hazlehurst, GAN1713JSimpson Mark E · Fairbanks, AKN1713RNevada General Enterprises Ltd · Reno, NVN1713VGrasshopper Flying Club · Poughkeepsie, NYN1714CMoreau Aviation LLC · Wasilla, AKN1714DBellenir Michael A · Mastic Beach, NYN1714GBull Rises LLC · Byron Center, MIN1714JFernandes Gary DBA · Clallam Bay, WAN1715CAerotrack Inc · Hemet, CAN1715DPulley Richard A · Chugiak, AKN1715FBradley Max T II · West Plains, MON1715WDlh Aviation LLC · Sainte Genevieve, MON1715YPacific Fleet Aviation LLC · Rochester, NYN1716CReidenbach John S · Kenosha, WIN1716EMccaskill William L · Hampton, VAN1716JNess Brian · Wasilla, AKN1716RRegistration Pending · Krum, TXRegistration pendingN1716TStratus Business Development LLC · Nashua, NHN1716XBell Brian · Oakland, CAN1717EN2893e LLC · Reno, NVN1717SXp Silva Air LLC · Rockaway, NJN1717WAdkins Zachary R · Scottsboro, ALN1717XSay Plastics Inc · Jacksonville, TXN1717YSeventeen Yankee LLC · Fort Lauderdale, FLN17180Newby Adam M · Anchor Point, AKN1718DSwe3 LLC · Seattle, WAN1718ECaptain Kenny J LLC · Holiday, FLN1718FSavage David E · American Falls, IDN1718GWhitlock Charles Parker · Thompsons Station, TNN1718HSale Reported · Bartlesville, OKSale reported, pending cancellationN1718RStripe Joseph · Olympia, WAN1719DHurd Matthew · Recluse, WYN1719FMoran Aviation LLC · Rose Bud, ARN171BCR Wesley Aviation LLC · Chandler, AZN171CAAircraft Parts Store LLC · Jacksonville, FLN171CEGarrison Randy · Queen City, TXN171DDNorfolk Aircraft Interiors LLC · Virginia Beach, VA
Back to AD 98-21-21 R1