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.
N85083Adkins Dwain L · Sycamore, ILN85085Medicine Bow Management Fund LLC · Helena, MTN85086Blackstone Aircraft LLC · Hartselle, ALN85087Mathews Scott P · Draper, SDN85088Knowles Greg · Reidsville, NCN85089Cattron Matthew · Webster, NYN85091Brutlag Paul D · Wendell, MNN85099Sale Reported · Belgrade, MTSale reportedN85101Whitman David L Jr · Sarasota, FLN85107Rude Holdings LLC · Raleigh, NCN85108Wilson Charles W · Mckinney, TXN85109France Donald R · Marcellus, MIN85114Richmond George H · Elkhorn, NEN85118Dunshee Anette M · La Luz, NMN8511ERichter Von E · Climax, GAN85121Hubbard Brian · New Brighton, MNN85122Houck Mark J · Fredericksburg, PAN85130Mcdowell Charles T · Pittsgrove, NJN85133Hanson Dirk Allen · Moorhead, MNN85138Acadiana Fixed Wing Rotor Wing Inc · Carencro, LAN8513ESessions Jaron B · Hemphill, TXN85141Talamo Robert F · Oswego, NYN85142Politte Timothy Jay · Sainte Genevieve, MON85147Kieffer Thomas P III · Columbus, INN85148Denys George A · Unadilla, NYN85151Wilson William L · Placerville, CAN8515ASale Reported · Cookson, OKSale reportedN8515ERegistered aircraftN85161Amiot Gary · Valdosta, GAN85163Schifano Benedict S · Scottsville, NYN85166Richardson Chasen M · Henderson, NVN85168Schutze Eric D Trustee · Ojai, CAN85170Watson Bobby M · Hoxie, ARN85173Ellis Jayson A · Benson, NCN85179Philpott Stuart L · Taylorsville, KYN85181Bas Part Sales LLC · Greeley, CON85182Welton Doug · Fairbanks, AKN85186Foley Ward · Westminster, CAN85188Hofeldt Jadrian B Trustee · Verona, WIN85189Delp Thomas W · Rensselaerville, NYN8518ELenbom Mark A · Cameron, WIN85191Fletcher John W · Burlison, TNN85192Daphna Inc · Middletown, DEN85194Gray Rex L · Palmer, AKN85198Bootz Patrick C · Lemmon, SDN85199Osprey Holding Company LLC · Foley, ALN8519EBumblebee Aviation LLC · Dayton, OHN85204Corriher Ronald R · Mount Ulla, NCN85207Blome Terry L · Pleasant Plains, ILN85216Russell Christopher Nicholas · Everett, WA
Back to AD 2000-25-02 R1