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.
N3002ETaylor Judith R · Lake Forest Park, WAN3005EOctagon Corp · Lewes, DEN3006EMiddletown LLC · Chandler, AZN3009EPollack Thomas H · Santa Monica, CAN300AKAmerican Champion Aircraft Corp · Rochester, WIN300CMBoehm Tristan C · Rake, IAN300WSOdyssey Aviation LLC · Raleigh, NCN3011EDouble Dose LLC · Kennewick, WAN3013EThompson Steve DBA · Pauls Valley, OKN3016ELutz Gregory J · East Bridgewater, MAN3017GBecker Lyle A · Anchorage, AKN3019EDobbelaere Rick H · Oakwood, OHN301ACFlying Squirrel Aviation LLC · Shirley, MAN3020ELacore Danny L · Flower Mound, TXN3023EGarrett Joseph · Saint Jacob, ILN3025ECody Plane Corp · Wilmington, DEN3029EConlin Michael T · Pawleys Island, SCN3032EDerick John Thomas II · Newburg, PAN3033E1941 Aircraft Group · Geneseo, NYN3035EHartman Michael A · Standish, MIN3039EFlory Daniel L · Elk Grove, CAN303ACUlinski Daniel J · Glen Burnie, MDN303SBBlom Wayne E Jr · Littleton, CON303SLBuffalo Aircraft Maintenance LLC · Ridgecrest, CAN3040ERegistered aircraftN3045GSlack Troy Trustee · New Concord, OHN3046EKnox Larry D · Parachute, CON304DFDevils Lake Aero Repair Inc · Devils Lake, NDN3059GStulp Annessa C · Lamar, CON3060Marishak Frank T Jr · Bedford, VAN3062EAdair Gregory M · Collierville, TNN3063EWoodson Robert L Jr · Ft Mill, SCN3064EFisher Hoke L · Peachtree Corners, GAN3066EMurray John M · Eufaula, ALN3068EWhatley Allen W · Catlett, VAN306ACHough Robert M · Windham, NHN3071EHendrickson Flying Service Inc · Rochelle, ILN3071GWetherbee Steven R · Pollock, SDN3074GOver The Top Aviation Inc · Jonesboro, ARN3076GFowler Gerald M · Hernando, FLN307MJSheridan Pilots 307 LLC · Sheridan, WYN307POetting William · Midland, ORN3084EBallard Lee · Morven, GAN3085GRegistration Pending · Wasilla, AKRegistration pendingN3088ELamphere Michael · Whitehall, NYN308EDStevens Mike · Duluth, MNN308KS J Fox Farm LLC · Corning, ARN308TATrinity Aviation LLC · Georgetown, TXN3091ECw & D Investment Inc · Riverview, FLN3094EJowett David J · Odessa, MO
Back to AD 2000-25-02 R1