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.
N479ACVick Vernon A · Dublin, OHN47DPMoler Alan D · Valley Center, KSN47VMCox Michael · Casper, WYN481ACVogel Lawrence O · Gig Harbor, WAN481DMEdgewood Capital LLC · Joplin, MON481EMClark Jeffrey V · Libertyville, ILN481MASlavens Timothy W · Howard City, MIN482ACClarke Jonathan Eric · Eustace, TXN4831EHardy John R · Wasilla, AKN4832ESenn David L · Oak Ridge, TNN4837EPfeffer William T · Amboy, MNN4838ERoberts Calvin D · Bluebell, UTN4839EHeckman Burt W · Mcclave, CON483ACTessos Air Service Inc · Wilmington, DEN4843EMoody Jerry W · Olympia, WAN4844EGroves Jamie L · Wasilla, AKN4848EConcannon Michael V · Indianapolis, INN484ACReist David A · Mount Joy, PAN484MAGibby Aviation Inc · Wilmington, DEN4850EGibson Timothy A · Frankfort, KYN4853ESummerfield Douglas T · Mason City, IAN4856ERiggin Flight Service Inc · Madison, SDN4857ESeverance Camden R · Milford, NHN4858ENantz William G · Raleigh, NCN485ACRambaut Paul C · Honolulu, HIN485TMitchell Lisa Marie · Lake Villa, ILN4864EMorgan Thomas A · Greenville, NCN4865EWorld On Our Time LLC · Lewes, DEN4866ECollier Charles R · Gloucester, VAN4869EHogue James R Trustee · Spring Valley, OHN4870EWells Kris G · Barron, WIN4871ESloss John W · Sterling, AKN4872EDippold Lois M · Perry, MIN4873ERice Johnny D · Rosharon, TXN4874EJenkins Don C · Wymore, NEN4876EFarrell Clifton S · Needville, TXN4878EPoklar Norman A · Mount Orab, OHN4879EPappas William B · Dallas, TXN487ACWhite Kenneth L · Saranac, NYN487DCFleming Michael P · Newberg, ORN4882EWalker Ray A · Sanger, TXN4883ECarricaburu Elliot A · Wasilla, AKN4884EPeck James M · Harrisburg, ARN4885ESharr Ken D · Bigfork, MTN4887EHicks J E · Opa Locka, FLRevoked, canceledN488LGErnst Donald E · North Pole, AKN488TCKoch Gregory S · Long Beach, MSN4894EPlyler Aviation Lp · Sherman, TXN4898EHagler Thomas J · Paradise, CAN489ACKuza Flyers LLC · Rock Hill, SC
Back to AD 2000-25-02 R1