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.
N8702VArrowhead Aeromotive Services LLC · Hoodsport, WAN87031Stewart Thomas E · North Pole, AKN87032Holland Mark S · Grenada, MSN87036Pino Carlos R · Santa Fe, NMN87038Thompson Christopher S · Senoia, GAN87041Seidl Charles F · Wasilla, AKN87043Young Boyt D · Hamill, SDN87044Fernandez Amador · Imperial, CAN87047Sprankle Gerard J · Fairbanks, AKN8704VAnderson Kirk M · Prosser, WAN87050Smith Daryl S · Bethel, AKN87052Migel Matthew J · Belgrade, MTN87057Zero Five Seven LLC · Fargo, NDN87061Podolak Charles J Pena · Phoenix, AZN87067Lassiter Robby F · Portland, ARN87079Darden Co Inc · Rolling Fork, MSN8707VBeckerwilliam M Trustee · Foristell, MON87084Flying Wild Arizona LLC · Anthem, AZN87090Graham John S · Sterling, AKN8709VFandrich Edward I · Payson, AZN870ACSessler Jay L · Sumner, WAN870DHJohnson Hangar LLC · Ridgway, CON870JLB&L Aviation LLC · Lewes, DEN870WTPesson Russell · Covington, LAN87109Van Voast Carla J · Turner, MTN8710HHickman Air LLC · Black Oak, ARN8712VKnobloch Jack F · Birney, MTN8717VSepko Joseph M III · Mebane, NCN8718VBecker Chris H · Panama City, FLN8719VBluemel Steve · Auburntown, TNN8721Jones Duane R · New Carlisle, OHN8721VEliasquevici Abrao · Ocala, FLN8724Fairhope Decathalon LLC · Fairhope, ALN8724VVintage Wings Aircraft LLC · Centerpoint, INN8726VLynch Christopher · Nashua, NHN872ACDoto Paul Jr · Santa Rosa, CAN872JMBlue Side Up Of South Carolina LLC · Central, SCN8730VPrater Christopher · Petersburg, TXN8731VSchutze Eric D Trustee · Ojai, CAN8732VEldridge Christopher Ian · Beaverton, ORN8733VDexter Fred H · Live Oak, FLN8735VPerras Bros · Morrisville, VTN8739Pridgen Blaine D · Breaux Bridge, LAN8739HShaw Brian W · Bemidji, MNN873ACAcfc LLC · Oak Brook, ILN8740VIngram Troy · Malin, ORN8741VLin Blake C · Portland, ORN8742VFollender Birns J C · E Islip, NYN8743VHayer Steven T · Laguna Beach, CAN8744VRees Lorin C · Camarillo, CA
Back to AD 2000-25-02 R1