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.
N1951EMcclure Steve · Lebanon, INN1956HWalker Benjamin R · Brasstown, NCN1957EHarper Robert A · Fort Myers, FLN1960PChaffee Harry · Meridian, CAN1962EAdkins Jonathan T · Belvidere, ILN1965EFollansbee Arthur B · Fairfax Station, VAN1967TSloan Jeffrey Sterling · Hazen, ARN1968EShaw Daniel C · Princeton, ILN196THHiers Timothy F · Barney, GAN1971EHoltaway Robert F · Bullock, NCN1973EStroud Richard M · New Market, ALN1976EMcdonald Jake V · Bowling Green, MON1978EPritchett Flying Service LLC · Rolla, MON1979EWomack Rob L Jr · Waco, TXN197BCSeruset Jeffrey G · Butler, PAN197NDKcsi Aerial Patrol Inc · Bakersfield, CAN1983ESmith Thomas A Trustee · Rogersville, ALN1984ZLynx Aviation Inc · King Salmon, AKN1985EChampion Expro LLC · Middlefield, CTN1986ETerry Rudolph G · Swarthmore, PAN1988EVonheeder Clinton Edwin · Plains, MTN198ACHutton Lisa · Rising Star, TXN198BCOconnell Tiffany LLC · Newbury, NHN198BJEllingson Jerry E · Lake Preston, SDN198EDKv Helicopters LLC · Lititz, PAN198JJHubbard Jordan · Boulder Creek, CAN198JTRibeiro Brian C · Clovis, CAN198QQuale Scott · New Town, NDN1997RUnd Aerospace Foundation · Grand Forks, NDN1998EHinson John F · Jefferson Hills, PAN199JCHeavy Metal Air LLC · Farmingdale, NYN199PHHutchins Matthew D · Birmingham, ALN199SAWin Win Aviation Inc · Wake Forest, NCN19AWFildes Robert D · Saint Charles, MON19BYPeralta Jose Ramon · Miami, FLN19CKBuckmeier Arlan M · Fairbanks, AKN19CWRussmann Nick S · Merit, TXN1ZZAnderson Jacob D · Algona, IAN2004ERazore Mark J · Ferndale, WAN2006ECollins Clyde R · Friendswood, TXN200MBPurple Plane LLC · Granbury, TXN200ZCTc Holdings Delaware Inc · Overland Park, KSN2013EDistad Jeffrey · Seneca, SDN2015EPebworth Mike L · Billings, MON2018EIndy Taildraggers LLC · Noblesville, INN2020EElsea Asa J · Circleville, OHN2022ASims Chad E · League City, TXN2025EDennen And Divine LLC · Rockville, INN2028EHintson John L · Pleasant Grove, ARN202JJCraig Guy R · New Castle, IN
Back to AD 2000-25-02 R1