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.
N7585BNorthern Light Aviation LLC · North Waterboro, MEN7586BTanner Michael John · Hooksett, NHN7586FJh Aviation Services LLC · Daisy, GAN7587EBroderick William E · Sterling, MAN7588BHenderson William Gary · Lake Worth, TXN7588FWilbanks Kari L · North Port, FLN7589FAerial Advertising Services · Livermore, CAN7591EYoung Carl J · Lubbock, TXN7591FFinger Lakes Soaring Club Inc · Dansville, NYFirst renewal noticeN7592BHotvedt Kyle T · Waupaca, WIN7593BCarhart Thomas M · Galesville, WIN7594FPierschbacher Clifton A · Marysville, WAN7595EFlynn Andrew L · La Grande, ORN7596BRiegelman Mark A · Manitowish Waters, WIN7597FKnowles Ross Martin · Chapmanville, WVN7598FDoggett Jacob R · Kingwood, TXN7599BRoblee Mark D · Raleigh, NCN7599FN7599f LLC · Camarillo, CAN759ESmith Donald H · Lagrange, GAN75ACIsland Charter LLC · Wilmington, DEN75BFScussel Edward D · Albuquerque, NMN75GKGrecor LLC · Ashville, ALN75MMDonney Tom J · Sturgis, SDN75SEJansen Adam Roger · Sunnyvale, CAN7600FGiles Forrest D · Springtown, TXN7602FPreston Aviation LLC · Mount Dora, FLN7603FJacobs Robert A · Grass Valley, CAN7614SNatural Pleasure LLC · Fayetteville, NCN7618SBraun Michael T · Oconomowoc, WIN7620BStancil James T · Jasper, GAFirst renewal noticeN7621SSmith Michael D · King George, VAN7623SKrejchik Daniel J · Portage, WIN7624SHovey Gregg Beecher · San Diego, CAN7625SN4457s LLC · Southport, NCN7627SJohnson Richard M · Osceola, WIN762KGDickens Randy L · Fuquay Varina, NCN7630SKidd Alan E Trustee · Louisburg, KSN7632SLocker Don D · Muleshoe, TXN7633SSageeyah Citabria LLC · Claremore, OKN7635SMcgaughy Robert E · Snow Hill, NCN7636SPrt Aviation LLC · Port Orange, FLN76382Registered aircraftN7650SMoore Aviation LLC · Westminster, CON7653STow Plane Idaho LLC · Boise, IDN7658SFlytwincos LLC · Las Vegas, NVN7659EEisberg Dean Paul · Eagle River, AKN765ACAllen Steven J · Pewee Valley, KYN7664SPekarek Robert K · Buda, TXN7665SPiercy Ronald S · Moses Lake, WAN7668SJacobson Luke W · Reno, NV
Back to AD 2000-25-02 R1