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.
N4134EPierce David R · Reidsville, NCN4134YLandon Jeff · Quartz Hill, CAN4135YMoore Steven J · West Ossipee, NHN4139EKrepfl Martin J · Colorado Springs, CON4139YPremier Management Co Inc · Mobridge, SDN413WPKcsi Aerial Patrol Inc · Bakersfield, CAN4140YBuckman Dean D · Monroe City, MON4141EEpmeier Bruce E · Newburgh, INN4141YWells Kevin R · Elko, NVN4142EBulldog Aviation LLC · Ely, MNN4142YRegistered aircraftN4143YHasenfus Heidi J · Green Cove Springs, FLN4145EMacgregor Wayne R · East Northport, NYN4147YReisdorf Steven R · Saint Cloud, MNN4148YTailwheel Flying LLC · Rochester, MNN4150EAnderson Kyle E · Palmer, AKN4150YFlying Bullfrog LLC · Virginia Beach, VAN4151EClark William · Easton, MON4151YWarner Kenneth G · Granbury, TXN4152ESchwend Brian · Forsyth, MTN4154RScheuerman Gary F · Athelstane, WIN4156YCummings Amelia D · Delta Junction, AKN4157YMclean Garrett Thomas · Soldotna, AKN4159EJohnson Lowell G · Trimble, MON4159YBauer Aviation LLC · Reese, MIN4160EWanda Collins Professional Pilot Services LLC · Madisonville, TXN4161EMaki Duane G · Wirt, MNN4161YWings Enterprizes Ltd Co · Yukon, OKN4162EGround Loopers Flight Club LLC · Gunnison, UTN4162YGarrels Gregory J · Salcha, AKN4163YWachter Bruce A · Maryville, TNN4164EVitale Andrew R · Middletown, NYN4166EMpms Inc · Munford, TNN41677Northern Aviation LLC · Palmer, AKN41678Dodge Donald V · Newnan, GAN41680Tailwheel Adventures LLC · Orlando, FLN41681Ralston Michael J · Calhoun, GAN41683Ferraro Jeffrey T · Mckinney, TXN41684Nenahlo Thomas L · Anchorage, AKN41686Atx Aero LLC · Austin, TXN41688Breunig Gerald S · Newark, ILN4168YThree Point LLC · Lacon, ILN41691Whiteknucle Aerobatics Inc · Blacksburg, VAN41693Glasford John T · Rapid City, SDN41694Damiano Charles J · Orcutt, CAN41695Guilfoyle Robert J · Shepherd, MTN41696Aaa Aviation LLC · Donalsonville, GAN41698Collier James R · Castle Rock, CON416SDTailwheel Adventures LLC · Celebration, FLN416SSChristie Ian A H · Limon, CO
Back to AD 2000-25-02 R1