AD 64-22-03
Registered aircraft · 1,567
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:64-22-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:64-22-03')
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:64-22-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:64-22-03') 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.
N101DHLarson David R · Boerne, TXN106JLinder Michael A · Arvada, CON1070BCurtis Julia A · Holladay, UTN108SGVahsholtz Matthew James · Conroe, TXN10NWLinzey David Wayne · Boone, NCN10SGBranyan Tyson E · Cushing, OKN110LFComanche Flyer Foundation Inc · Blaine, WAN11151Kowest Aviation LLC · Enid, OKN111LFZimmerman Leland · Center, CON111SLKaehlert Lottie DBA · Rifle, CON112WSEdgeington Randall K · Riverton, WYN114XTaft Plumbing Co Inc · Taft, CAN119EAce Aeromotive Inc · Miami, FLN120SGlenn Robert · Boulder, CON12134Everson Corey A · Madison, ALN1220ZColumbus State Community College · Columbus, OHN1223Munning Joseph H Md · Jasper, INN123HMComanche Air LLC · Mokena, ILN124NREckhoff Daniel · Ramsey, MNN12RDFlying Colors Airparts Inc · Leesburg, FLN136YJanoski David M · Fort Worth, TXN142CATack Kenneth W · Taft, CAN1440XAlldredge Brad · Redlands, CAN144TLNielson Mark Allen · Willmar, MNN146PWilliams Mike C · Sonora, TXN14FCJwc59 LLC · Newnan, GAN14YPHubbard Scott Edward Jr · Deatsville, ALN156DCEaton Billy J · Bridgeport, TXN15QAQuiet Aero LLC · Fort Myers, FLN160LMMino Leonard G · Pueblo West, CON161PRegistered aircraftN16DPNdmi Inc · Greeneville, TNN175MBKlein Robert · North Garden, VAN17TARetired Aviators Flying Club LLC · Oklahoma City, OKN180MLBearden Harold H · Haleyville, ALN1901PTurner William D · Southaven, MSN1959PTanner Greg L · Bend, ORN199JTPena Rivera Luis A · Zephyrhills, FLN1XACowell Aviation Maintenance LLC · Easley, SCN200DBDelta Bravo Inc · Davie, FLN2024PYounhorsh Sales LLC · Wilmington, DEN20RDickerson Stephen R · Frisco, TXN212GPWibel Enterprises Inc · Crossville, TNN212RGGillum Reef · Clint, TXN2172MPacker Bruce P Trustee · Tempe, AZN218SAInternational Air Services Inc Trustee · Carson City, NVN221DFMoeckel Herbert R · Tunas, MON2222ZParsons John C · Wichita, KSN222HLDouble K Flying LLC · Scottsboro, ALN224KJam Three LLC · St George, UT
Back to AD 64-22-03