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.
N83415Murray Donald L · Two Harbors, MNN83420Leonardi William J · Jamesport, NYN83425Graber Donald L · East Thetford, VTN83426Smokovitz Joseph M · Tecumseh, MIN83427Registration Pending · Milton, TNRegistration pendingN83429Gultch Dale R · Brookfield, WIN8342VPrecision Aerial Ag LLC · Seneca, KSN83430Harter Michael R · Greenfield, INN83431Fredrickson Richard · Granite Falls, MNN83436Milligan Reid D · Catawba, NCN83439Mckinney Steve · Hamersville, OHN83440Wright Eric K · Wills Point, TXN83445Diewold Jeff E · Burlington, IAN83448Baker Thomas N · Grove, OKN83450Fish John F · Fayetteville, GAN83457Havener Hunter W · Chittenango, NYN83460Davis Ralph · Canon, GAN83465Frost Beverly J · Greenfield, INN83468Skyhawk Aero LLC · Montevideo, MNN83469Morgan Jeffrey S · Utica, INFirst renewal noticeN8346VLovley Linda C · Jordan, MNN83474Canyon West LLC · Amarillo, TXN83478Barker Edward J · Claremore, OKN83479Connor Timothy J · Kirtland, OHN83483Moore Michael E · Renton, WAN83487Wilkins John K · Montgomery City, MON83488Borzoya Aero Group Inc · Slatington, PAN83489Flavell John P · East Bridgewater, MAN83495Heidbreder Mark A · Liberty, ILN83496Rich Aviation Services LLC · Fort Worth, TXN83499Vetrone Troy D · Wisconsin Rapids, WIN83500Snodgrass Richard T · Simpsonville, KYN83502Robinson Samuel C · Brighton, TNN83504Oak Ridge Flyers Inc · Oak Ridge, TNN83507Wrasse Mark R · Rosholt, WIN8350VMertz Rachel A · New Ulm, MNFirst renewal noticeN83515Chirtea John · Milton, DEN83518Cosentino William D · Lees Summit, MON83520Songer Dylan · Veedersburg, INN83521Lequire Wayne A · Maryville, TNN83526Mccord Mark Harlan · Valleyford, WAN83533Brewer Brandon B · Jonesboro, ARN83538Lee Justin W · Maud, TXN8353VN8353v LLC · Monroe, LAN83542Vinyard Herbert O Jr · Hammond, LAN83544Williams Theodore · Marietta, OHN83548Johnston Stephen P · Hawley, MNN83555Middletown LLC · Chandler, AZN83557Pressley Brandon S · York, SCN83561Hutzler Matthew T · Chetek, WI
Back to AD 2000-25-02 R1