AD 72-02-06
Registered aircraft · 2,299
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:72-02-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-02-06')
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:72-02-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-02-06') 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.
N1800XValentine Edward Lawson · Dallas, TXFirst renewal noticeN1801XClark Curtis S · New Carlisle, OHN1801ZGould Robert R Jr · Sterling, VAN1802FSantiago Ferdinand · Calhoun, GAN1802ZSparks Timothy J · Jackson, MIN1804FWaage Todd · Greenbush, MNN1806XBrowning Lonnie O IV · Allendale, SCN1808XM&M Land Company LLC · Marietta, OHN1808ZFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVNon-citizen corporation, flight hours not reportedN1809XMilburn Thomas D Trustee · Lompoc, CAN1809ZCleared For Departure LLC · Kennewick, WAN1810ZRanzway Corp · Seattle, WAN1811XAircraft Guaranty Corp Trustee · Oklahoma City, OKN1812XDavid Glen E · Ash Fork, AZN1814FAlpine Cable And Construction Inc · Grand Junction, CON1817XSale Reported · Roseville, MNSale reported, pending cancellationN1819XGrant Steven T · Sellers, SCN181CPEighty1 Aviation LLC · Canton, GAN181DHWinkler Jeffery L · Brush, CON1820ZStaats Douglas E · Anchorage, AKN1821SBailey Ralph E · Sikeston, MON1821XCluer Brian L · Bodega, CAN1822ZAhrens Kevin Michael · Cashmere, WAN1823XN1823x LLC · Middletown, DEN1825ZGreentek Inc · Oroville, CAN1827XFlatland Farms LLC · Hooker, OKN1828ZHorrocks Charles M · Blackfoot, IDN1829XWise Dennis E · Battle Ground, WAN182ARRyan Jeffrey W · Westminster, CON182CJJackson George K · Jonesboro, ARN182DBBender Flight LLC · Camano Island, WAN182DHWills James M · Farmville, VAN182GEGmr Leasing LLC · Lincoln, DEN182HAvquad Inc · Fort Collins, CON182JENunatak Air LLC · Fairbanks, AKN182JJJ & J Aero · Chuckey, TNN182KFPlante Matthew · Blackstone, MAN182LDLutian Mark J · Raymond, MEN182LHHudspeth Lance A · Redmond, ORN182MService Oriented Aviation Readiness (Soar) · Bolivar, MON182SRBaldwin Steve · Kearney, MON182TFHigh-Wing Aero LLC · Albertville, MNN182TPBurkeen Timothy Charles · Prescott, AZN182UKMarshall Christopher E · Boise, IDN182ULMedia Stew LLC · Carson City, NVN182WHSorensen Welding Inc · Mahnomen, MNN182WLMckaye Thomas · Santa Paula, CAN182WYWind River Flyers Inc · Pinedale, WYN182YHParker Nicholas · St Maries, IDN182YSYuba-Sutter Aviation Inc · Olivehurst, CA
Back to AD 72-02-06