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.
N922TJBowar Gary R · Miranda, SDN922WSWerth Jill · Canandaigua, NYN9232EHughes Justin L · Cedar Hill, TNN9239EMasephol Todd M · Athens, WIN923SQSprecher Susan E · Locust Grove, GAN9242ERegistration Pending · Milton, FLRegistration pendingN9243ERegistered aircraftAssigned, pending cancellationN9244EFrost Beverly J · Greenfield, INN9245EJensen Jeffrey S · Alliance, NEN9246EPolhemus Christopher C · Carmichaels, PAN924JWStephenson James M Jr · Hyampom, CAN9252EHartzler Richard B · Grandview, MON9255ERule Paul C · Wapato, WAN9258VTomczak Christopher · Intl Falls, MNN925ERCrosswell Joe D · Springtown, TXN9260EStruck Larry G · Gardnerville, NVFirst renewal noticeN9261EMcvay Frank A · Bonaire, GAN9262ESilvers Jason A · Chilhowee, MON9263EWojdac David E · Mosinee, WIN9264ENewcombe Emily S · Cascade, IDN9265EMikesell Clifford W · Rochester, INN9267EErb Charles Allen · Holden, MEN9268EPancake C William Jr · Keyser, WVN926BWTrade Winds Aviation Holdings LLC · Lewes, DEN926JPJl Aviation LLC · Crestwood, KYN9271EHargrove Dwayne E · Shepherdsville, KYN9276EGriebsch James J · Saranac Lake, NYN9278EMurray Richard H · Celina, OHN9279EHood Paul A · Saint Johns, MIN927SANpg Group LLC · Missoula, MTN927WTHaugen Delos L · Burlington, NDN9283EErickson James R · State College, PAN9284EDexter Fred H · Live Oak, FLN9287DWilson Robin W Trustee · Fairbanks, AKN9288EMurray Richard H · Celina, OHN9290EMentgen William P · Greencastle, INN9291ECadotte Anthony John · Minnetonka, MNN9293EMerrill Steven W · Proctor, MNN929ACWitman Michael R · Milliken, CON929ELPatterson Bryan J · Brooks, GAN929FMParker Johnny W · Murray, KYN92GKRatchford Herman Jr · Bessemer City, NCN92KBRaphael Dennis C · Colorado Springs, CON92SGStraight And Level LLC · Woodbine, MDN9300ECoy Shane A · Nenana, AKN9304ECarroll Charles · Ephrata, PAN9305EWittmeyer Jody M · Dandridge, TNN9307EChaudhary Rizvon · Louisville, KYN9308EReynolds Richard E · Trumansburg, NYN9309EHenderson William R · Ohatchee, AL
Back to AD 2000-25-02 R1