AD 2001-22-01
Registered aircraft · 276
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:2001-22-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-22-01')
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:2001-22-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-22-01') 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.
N5690DRolfe Cameron R · San Mateo, CAN5690KAircraft Guaranty Corp Trustee · Oklahoma City, OKN5690PMultiaero Corp · Brooklyn, NYN5691MBrowning Robert F · Washington, DCN56926Bitwell Construction LLC · Hartville, OHN5692YSilverado Sales Inc · Orem, UTN5693RWaters Willie Frank Jr · Willits, CAN5694AStyer David B · Pendleton, ORN5694NBegley Edward · Glasgow, KYN5695AJacob Ricker · Ranchester, WYN5696MHubbard Benjamin L · Quogue, NYN5697MStanton Mark I · Spokane, WAN5698ELrh Equipment LLC · Pendleton, ORN56999Lofty Images LLC · Owosso, MIN5699DClear Lake Management Corp · Wilmington, DEN5699NStyer David B · Pendleton, ORN5699ULrh Equipment LLC · Pendleton, ORN5699VMesmer Robert F · Grand Island, NYN56UD&M Aviation Inc · Amelia, OHN572HCordrey Kenneth R · Delmar, DEN58FSClark Mitchell P R · Drewsey, ORN594HKeading Helicopter LLC · Shoshone, IDFirst renewal noticeN595ARMiddle Fork Aviation LLC · Meadowview, VAN59AXCentral Virginia Aviation Inc · North Dinwiddie, VAN59FSRegistration Pending · Yazoo City, MSRegistration pendingN600RBGates Steven · Midlothian, TXN602HKing John H · Trumansburg, NYN613AHEnstrom Helicopter Corp · Menominee, MIN61GGCoggin Randall · Longview, TXN624CECertified Equipment Inspections LLC · Washington, PAN624HNeed For Speed Inc · Dover, DEN62VATiger 17 LLC · Wilmington, DEN631DPHeritage Rotors LLC · De Leon Springs, FLN643HHagglund Caleb J · Pendleton, ORN646HStyer David B · Milton Freewater, ORN652MTThomas Michael W · Prescott, WAN656XMackechnie Martin J · Palm Harbor, FLN663DSButler Raymond · Port Lavaca, TXN665HHouchin Thomas J · Pittsburgh, PAN666CFTrofimchuck Matthew P · Coal City, ILN666MDLrh Equipment LLC · Pendleton, ORN668ZEEnstrom Helicopter Corp · Menominee, MIN669CEOne Pft LLC · Denton, MTN698MBravo Zulu International Ltd · Las Vegas, NVN700ATMoore Stirling · Douglas, WYN704DFrancis Greg · Texarkana, TXN70719Emerson Frayne · Stanfield, ORN713CHHopkins David Martin · Bell Buckle, TNN726RMEaves Christopher C · Salt Lake City, UTN728DBStyer David B · Pendleton, OR
Back to AD 2001-22-01