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.
N7670SShortridge Randall R · Mesa, AZN7671SKlos Aero LLC · Plevna, MTN7672SLouisville Soaring Club Inc · Lexington, KYN7674SMurtagh Johhny T · Lexington, MSN7675SKemp Gilbert A · Waterville, NYN7677EPatterson Judy K DBA · Rutherfordton, NCN7678ETerry Michael R Trustee · Bullhead City, AZN7679EColorado Express LLC · New Port Richey, FLN767ACWooldridge Kent L · Albany, ORN767PAviation Investments Inc · Virginia Beach, VAN767RAmerican Champion Aircraft Corp · Rochester, WIN767SECoyote Aviation LLC · Carefree, AZN7680EC & C Farms Partnership · Epps, LAN7680SHallsten Stephen B · Fairbanks, AKN7681SCawley Jeffrey W · Buckley, WAN7683SSzabolscky Stephen L · Remington, VAN7684SStrehle Scott · Lewiston, IDN7685EDougherty Jeff D · Connell, WAFirst renewal noticeN7685SHull Kevin G · Sadler, TXN7686EChristie Ian A H · Limon, CON7687SLynn Robert W · Independence, WVN7688SJohnson Brian G · Goodridge, MNN768ACBowe Joseph E · Ocklawaha, FLN768CStieren George L · Kerrville, TXN768TPjd Holdings LLC · Grand Blanc, MIN7690SCollum Aviation LLC · Milton, FLN7692EBrickwood-Figgins David B · Tulsa, OKN7693EBrignac Flying Service LLC · Columbus, MSN7694EWilliams Lisa Goulet · Summerland Key, FLN7694SBaker Bruce A · Chandler, AZN7695EReynolds William H Jr · Norfolk, VAN7695SState Of Alaska · Fairbanks, AKN7696EReedy James · Fairfield, IDN7697SKenley Fredrick Charles · Palmer, AKN76BCYackley Ranches · Onida, SDN76BEBrown Darrell W · Covington, GAN76DESchiff Brian · Keller, TXN76KFRegistration Pending · Grenada, MSRegistration pendingN76MLDunn Courtland E Jr · West Grove, PAN76PPGround Effect Aviation LLC · Ogden, UTN76SMCasey Mike P · Whitefish, MTN76YDBeasley Charles A · Spencer, VAN7704SHolte Bruce C · Thief River Falls, MNN770ACSearching For Grass LLC · Stroudsburg, PAN771ACMorrison William Fraser · Bonners Ferry, IDN771CTCrump John · Gillette, WYN771LLBravo November LLC · Wilsonville, ORN771MRSmith Nathan · Palmer, AKN772ACMiller Kevin W · Epps, LAN772EMelvin Daniel · Larkspur, CA
Back to AD 2000-25-02 R1