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.
N3813EMitchell John J · Whitewater, WIN3814EAllen Anwaar Saeed · Pueblo, CON3816ESpark I Aviation LLC · Wichita, KSN3817EEccles Vickie L · Beaver, OKN3818ETomanio Richard E · Saint Augustine, FLN381CAOltman Neil R · Sandia Park, NMN381DMStuart John R · Taylorsville, KYN381MAKnight Wings LLC · Matthews, NCN3823ELanglois James F · Merrill, WIN3824ESheldon Brandon A · Houston, TXN382MAFly To Sea LLC · Stanford, CAN3834ESchmitz Patrick A · Wynot, NEN3835EAviation Covers Inc · Arlington, WAN383ACWest Valley Flying Club · Palo Alto, CAN3843EJoyce Chantz · Cottonwood, CAN3844XFernandez Amador Jr · Imperial, CAN3853EKownurko Evan C · Elmira, NYN3854EPringle Anthony A · Durham, MEN3857ERegistration Pending · Monroe, LARegistration pending, pending cancellationN385BCRobinson Eric C · Palmer, AKN385EASchuch Glenn F Jr · Dubois, PAN3865EChecky Allen O Jr · Merrimac, WIN3867EKrogsrud Stephen · Pasco, WAN3868EShaw Timothy · Columbus, INN38691Dye Benjamin L · Union Springs, NYN386ASSandstrom Allan A · North Ogden, UTN3874EMelton James A · Conway, ARN3876EMurphy Terrence W III · Belmont, NHN3882ES&D Aero LLC · Elmira, ORN3883EBigham Brent A · Trion, GAN3884ENiemyjski Trevor G · Union Grove, WIN3885ECalgaard Gary · Clear Lake, IAN3887ESchorsch Cary J · Franksville, WIN3892EFerriter John M · Waterville, NYN3894ESchulze William Leo · New Bremen, OHN3898EBoss Gary W · Bronston, KYN38ACCesafsky Allen A · Trinity Center, CAN38HSHenderson State University · Arkadelphia, ARN38LTStevens Richard D · Isola, MSN38MBWest Joseph A · Ballston Lake, NYN38SMTieder Sheldon D · Rhinebeck, NYN38TGJohnson Tracy W · Odessa, MON38WHButler David · Palos Park, ILN38WKFoley Stephen T · Kerrville, TXN3900ECanepa Joseph H · Baraboo, WIN3901EMcginnis Louis F · Raton, NMN3906ESale Reported · Port Saint Lucie, FLSale reportedN3909ESutton Aircraft Salvage LLC · Palmer, AKN390ACEtcheverry Raymond L · Sunriver, ORN390PEBoney Grady F · Rhine, GA
Back to AD 2000-25-02 R1