AD 2000-25-02 R1
Registered aircraft · 7,563
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.
N6399NMcguire Zach T · Jasper, MON63AKWinchell Lawrence R III · Salem, NJN63BCValleortiz Hector J · Laurel Hill, NCN63CVClark Terry L · Bartlesville, OKN63DABass Lake Aviation LLC · Webster, WIN63HALmn Aircraft Leasing LLC · Sellersburg, INN63HESkoog Rodney D · White Bear Lake, MNN63MYRegistered aircraftN63WTRodencal Richard · Wisconsin Rapids, WIN6404CWhiteside Donald J · Santa Cruz, CAN641MAAscent Aviation Inc · Duluth, MNN641PPhilip Mark A · Leesburg, VAN6420CSloan Donald W · Dover, DEN64273Bacon Robert · Northampton, MAN6430DHartley Roger Lee · Bridgeport, WVN6433CSandy Kenneth Kd IV · Meridian, MSN6434COliver Frank E · Albany, ORN6436CUnsicker Thomas D · Chimacum, WAN644CMMckenzie Bradley J · Houston, TXN644MPPasztalaniec Matthew S · Monterey, CAN6451CAgaliotis Paul E · San Martin, CAN6476CWerden Lawrence Mel · Pinconning, MIN6477AAllen Chad R · Olathe, KSN6478CLoeding Larry · Diberville, MSN64ACRm Thomas Co Inc · Lewes, DEN64AKKenley Fredrick · Palmer, AKN64ESBaron Alan E · Boulder, CON64MKCavanaugh Sean M · Ottumwa, IAN64PZMountain Aeroscout Adventures LLC · Park City, UTN64VHHealey Richard · Tracy, CAN650GSDiebel Darrel L · Okanogan, WAN651DMAircraft Guaranty Corp Trustee · Oklahoma City, OKN654ACFlying Sparks LLC · Tomball, TXN654JSSass James Louis Jr · Abilene, TXN654SMMcbride Stuart · Kingsland, TXN655ACAuxier David R · Baker City, ORN655SKMassey Roger L Trustee · Nipomo, CAN656WCT3 Aerosports LLC · Vian, OKN65783Farber Jason · Tracy, MNN657MVLeyden Aviation LLC · Dover, DEN65880Miller James L · Galena, ILN65890Beyler Mitchell L · Hamlin, NYN65891Cone John M · Conyers, GAN658TAmerican Champion Aircraft Corp · Rochester, WIN658WHHousley William M · Jasper, ALN659HCHowlett Corey · Wasilla, AKN659MAStringham Charles A · Winnemucca, NVN65AWSmith David W · Byhalia, MSN65TVVandenbosche George Thomas · Hidden Valley, PAN65UFWright Stanley E · Houston, TX
Back to AD 2000-25-02 R1