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.
N68KAAakre Keith E · Granite Falls, MNN68MEPeigneux Brothers Llp · Malta, MTN68NDSand Nicholas Patrick · Alta, IAN690SHCorriher Mark B · Mocksville, NCN695ACHodgson Daniel J · Anchorage, AKN695HCCurrence Louanne J · Rock Hill, SCN696SPMj Paws LLC · Wilmington, DEN697FCBlackhawk Holding Corp · Wilmington, DEN69968Henrikson Peter R · Fort Worth, TXN699DMBarber Christopher A · Toney, ALN699TAmerican Champion Aircraft Corp · Rochester, WIN69AUThoma George E · Old Lyme, CTN69BYLaird Bernie J · Appleton, WIN69GCEwald John · Seguin, TXN6BCBest John · Cave Creek, AZN6BNDevencenty Natalia · Pueblo, CON6FDScud Air 6fd LLC · Morgan, UTN6HMHenning Nancy E · Hardinsburg, KYN6NDLind Mitchell W · Polk City, FLN700Dailey Jeffrey D · Weirton, WVN700CNHoleshot Aviation LLC · Lodi, CAN700MGGeorgia Aviation Authority · Eastman, GAN701EPErpco LLC · Wilmington, DEN701HGGeorgia Aviation Authority · Eastman, GAN702BSTwo Bravo Sierra LLC · Auburn, CAN702MGAmerican Champion Aircraft Corp · Rochester, WIN702NVAca Sd LLC · Kalispell, MTN7047CAerospace Trust Management LLC Trustee · Wilmington, DEN7054QCarpenter Gary W · Junior, WVN7056CKing Bernard E Jr · Laurinburg, NCN705NRState Of Minnesota · Grand Rapids, MNN705RBYakubinis William J · Charlotte, NCN70603Massman Darrel F · Ogdensburg, WIN7062PHryniewicki Walter E Jr · Chippewa Falls, WIN7065ECleveland Lorne · Tyler, TXFirst renewal noticeN7070JNickerson William L · Libby, MTN707BCJagair LLC · Riceville, TNN707GPIntermountain Air Inc · Colorado Springs, CON707RTRomeo Tango LLC · Indianapolis, INN707WMSnake Bit Aviation LLC · Pelham, GAN7081JHumphrey Neil F · Laramie, WYN70824Heidebrink James M · Bloomington, ILN7096JHutfless Roger P · Davenport, WAN70SFFred Stuart L · Houston, TXN7100EStrickler Elizabeth D · Ringgold, TXN710TLBarker John Van · Smyrna, GAN711BCSummit Air One Inc · Wilmington, DEN711DQNtx Citabria LLC · Wichita Falls, TXN711JJReady Aim Flyer LLC · New Castle, DEN7125Epton Richard W · Barnesville, GA
Back to AD 2000-25-02 R1