AD 91-22-01
Registered aircraft · 1,525
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:91-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:91-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:91-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:91-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.
N210JRowdy Mcbride Hunting Services LLC · Alpine, TXN210JRSouthard Robert W · Elk City, OKN210JVCenturia LLC · Fort Lupton, CON210JZD & B Innovations LLC · Amarillo, TXN210KHitchcock Mark James · Scottsdale, AZN210KCFluid Media Inc · Moscow, IDN210KEKampel Thomas E · Wellsville, PAN210LDPurcell Darrell Ray · Yuma, AZN210LXColeman Daniel N · Phoenix, AZN210MRegistered aircraftN210MMMarble Aviation LLC · Ball Ground, GAN210MYIts Always Something LLC · Winter Haven, FLN210NBurton Stone LLC · Durango, CON210NHMoore John R · Acworth, GAN210NMSouthern Aircraft Consultancy Inc Trustee · Casper, WYN210NSNovember Sierra Aviation LLC · Oneill, NEN210PEVan Dyke Gary D · Pleasant Grove, CAN210PRShaw Ronald V · Edmond, OKN210PZKmz Centurion LLC · San Mateo, CAN210RRBeasley Emmett C · Bixby, OKN210RZKk Hangar LLC · Little Rock, ARN210SCSpence C Jason · New Braunfels, TXN210SWSierra Whiskey Aircraft LLC · Saint Louis, MON210SYBluegrass Air Systems LLC · Nicholasville, KYN210TBGurnee Steven H · Granite Bay, CAN210TFAll About The Doodles Inc · Kirkland, ILN210THHeffley Terry · Granbury, TXN210WKCorrado Christopher · Newton, NJFirst renewal noticeN210WLBskt210 LLC · Hartsville, SCN210WMBryan-Kennedy LLC · Tulsa, OKN210WSOlin David G · Jupiter, FLFirst renewal noticeN210WVHiservant Ministries Inc · Mont Belvieu, TXN210XLInternational Air Services Inc Trustee · Carson City, NVN210XXRegistration Pending · Porter, TXRegistration pendingN210YPartners Aviation LLC · Wilmington, DEN210YYApr Aviation · Fresno, CAN210ZPThaggard Aviation LLC · Leesburg, GAN2110S2f Trade LLC · Gainesville, TXN212GBSooner Farms LLC · Siloam Springs, ARN214GGilpin Sean F · Madison, ALN2151SSd Aviation LLC · Syracuse, KSN2157SSchlenker Wesley E · Dallas, TXN215JInnovative Aerodynamic Technologies · Yorktown, VAN2160SGalkin Edwin N Dmd · Edison, NJN2170SAboveallphoto.Com Inc · Indianapolis, INN2177SFerkin Planes LLC · Caldwell, IDN21BMGandee James T · Bullhead City, AZN221AARegistered aircraftN221BFXtratech Corp · Davie, FLN22202Gifford Gregory L · Naples, FL
Back to AD 91-22-01