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.
N622ACAj Aircraft LLC · Yarmouth, MEN622CBBestland Roger J · Webster, MNN6231LDelong Thomas S · Fairbanks, AKN624APThomas Lucas G · Beebe, ARN625APThomas Lucas G · Beebe, ARN625BCCorwin Bert C · Rapid City, SDN625DMToftness David R · Clear Lake, WIN625KBDoran Jeffrey T · Westerville, OHN625MLGunsauls Michael A · Red Bluff, CAN625TOil Belt LLC · Lewes, DEN62667Michael Nebinger Henley Jr · Columbus, GAN62669Eckelman Keith R · Culver, ORN626APDobry Robert S · Crescent City, FLN627APRegistered aircraftN627ECGormon Michael L · Colville, WAN6283CBaker Mike D · Benton, KSN6284CYardley & Co Inc · Quinn, SDN6285CMiel Jerry A Trustee · Green Valley, AZN6286CHubbard Mark A · Wilmington, DEN628APThomas Lucas G · Beebe, ARN628TCLayton James L · Carrollton, GAN6294BAusten Tim · Oregon City, ORN62964Phelps Larry D · Vinton, IAN62965Mckenna David M · Newell, IAN62966Walker Richard E · Quanah, TXN62968Stanley Farms · Grygla, MNN62975Quintessence World LLC · League City, TXN62976Shales Rene J · Hampshire, ILN62977Borgerding Richard · Piqua, OHN62979Cummings Roy E · Fort Scott, KSN62982Peterson Derek R · Kenmare, NDN62984Hopkins George · Chippewa Falls, WIN62985Alexander Aviation LLC · Brighton, CON629APThomas Lucas G · Beebe, ARN629PJWittmayer Mark A Trustee · Orlando, FLN629PKJones John Michael · Oologah, OKN62FESouthern Aircraft Consultancy Inc Trustee · Casper, WYN62FTAhgl LLC · San Diego, CAN62RHBianco John R · Massapequa, NYN62WWPc-Ppp LLC · Jersey City, NJN6300NGriesman Scott W · Sandy Valley, NVN6303NTaylor Timothy P · Watford City, NDN6305NPerera Nandana L · Logan, OHN6306NSmith Michael J · Chebanse, ILN6308NJ Squared Enterprises Corp · Hendersonville, TNN6309NJohnson Darrick C · Wolford, NDN630APThomas Lucas G · Beebe, ARN6310NHumbert Jeff M · Cottonwood, CAN6312NSmith Sabra L · Danville, CAN6316NLeyes Richard A II · Janesville, WI
Back to AD 2000-25-02 R1