AD 2000-25-02 R1
Registered aircraft · 7,560
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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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.
N1664GTownsend Virgil P · Yukon, OKN1665ETeichman Betty H · Venice, FLN1666EBelanger Paul L · Westbrook, MEN1667GEngel Craig D · Amboy, INN1668EDehn-Reynolds Mary M · Searsport, MEN1668GNewport Signal Air Inc · Anacortes, WAN1669EKangas Ralph A · Donnelly, IDN1669GTaylor Michael P · East Olympia, WAN166DBStokes Lowell W · Kingwood, TXN166RSThiessen David · Brownsville, TXN1670GKing John D · Midland, VAN1672GGivens Benjamin T · Ruffin, SCN1673GLake Robert F · Mechanicsville, MDN1675GKraft Jesse · Twain Harte, CAN1676GCain Landa B · San Diego, CAN167BWMartin Jennifer · Palm Desert, CAN167PCBlue Mountain Flyers Inc · Palmerton, PAN167RAWojnar Ronald T · East Troy, WIN167TCFarzaneh-Far Ramin · Brookline, MAN1680GSears Richard A · Stevensville, MDN1681ERoy David J Sr · Clinton, NYN1684GMitchell Gary N · Kansas City, KSN1685GBrisson Gisele A · Hollister, CAN1687GSimon Mitchell B · Edison, NJN168BCWildlife Air LLC · Dubois, WYN168JMMarshall John A · Pacific, MON1690ELaplante Bruce · Vilonia, ARN1690GRansom Bryce P · Richland, ORN1691EUhlemeyer William A · Alvin, TXN1691GPalmer Christopher John · Upper Lake, CAN1691NFletcher Flying Service 419 LLC · Labelle, FLN1692GSmith Theodore M · Van Buren, MEN1693EHanger Brian R · Ethel, WAN1695GSmith Winston R · Durham, NCN1696GRives James · Moore Haven, FLN1697GConnell Edward A · Crescent City, FLN1698EHunter Jared P · Somerville, MAN1699GBeckham Samuel G · Saint Charles, MON169DDFlughafen Skyport Ltd · Wilmington, DEN169EZMallory Jessica Lynn · Anchorage, AKN169PCSachau Glen R · Spearfish, SDN169RADavis John A · Cabot, ARN16BYYoung David L · Oakwood, ILN16DVDecathlon LLC · Herndon, VAN16RGHomer Ace Inc DBA · Tulsa, OKN16TPWorsham Farms Flying Service Inc · Camilla, GAN16VUVipers United LLC · Stoughton, WIN1700EErfle Gordon A · Rapelje, MTN1701HAmelia Reid Aviation LLC · San Jose, CAN1703ERegistration Pending · Columbia, SCRegistration pending, pending cancellation
Back to AD 2000-25-02 R1