AD 72-01-07
Registered aircraft · 1,150
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-01-07')
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-01-07')
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-01-07') 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-01-07') 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.
N1627APlettner David C · Sutton, NEN1636AHilliard John · Olympia, WAN163TKloes Michael L · Everett, WAN1650PChilcote Gary D · Britt, MNN1651PCaron Ty · Redmond, ORN1652PCcf Ventures Inc · Bangor, MEN1653PAirmotive Service LLC · Brigham City, UTN1658PSmith Gregory · Lewistown, MTN165TGrove Robert P · El Cajon, CAN1662PRyan Dietrich Farms Inc · Scottsbluff, NEN16688Water Wings LLC · Buckley, WAN166TBuechle Tim P · Talkeetna, AKN167TTouchstone Gwendolyn M · Villa Rica, GAN1701ACirri Joseph A · Deming, NMN17080Van Wagner Aerial Media LLC · Hollywood, FLN170TStoltzfus Sandra · Kidron, OHN172TMissaukee Aircraft Leasing LLC · Cadillac, MIN1738ALyall Gregory S · Anchorage, AKN1754ASchrock Jaden D · Sterling, AKN1754PLorring Eric H · Kodiak, AKN1755ASchultheis John U · Wasilla, AKN1759AHargus Betty R · Fort Stockton, TXN1765PHendry Robert L · Lysite, WYN1783ASatra Jerry · Savage, MTN1788ADavis Nigel L · Helena, MTN1793AHickle Lucas · Wasilla, AKN1795ASvendsen Gregory Roy · Anchorage, AKN1798ASlow Goose LLC · Chevy Chase, MDN180TWatanabe Masayuki · Harbor Oaks, FLN18141Schulte James P · Hurst, TXN181AWKustatan Leasing LLC · Nikiski, AKN181TWatkins Steven B · Roxboro, NCN1820ACaley Robert M · Green, KSN1829AMcelligott Joseph P · Ione, ORN1841AJohnson Kevin L · Canyon, TXN1850AWells Kris G · Barron, WIN1852PBennack George H · Lyford, TXN1853DBent James L Jr DBA · Palatine Bridge, NYN1855AMoore Brandan D · Wasilla, AKN1857PJanvrin Jerry M · Buffalo, SDN1858ALow And Slow LLC · Bozeman, MTN1861ABernstein Timothy D · Faith, SDN186TKing George W · Strykersville, NYN1871ASkywagon Aero LLC · Wilmington, DEN1876AKalarney Kerry T · Olathe, CON1878ANapa Taildraggers Inc · Napa, CAN1878PLutter Jim L · Gann Valley, SDN1879ASale Reported · Eagle River, AKSale reported, pending cancellationN1882PAir Dakota Flite Inc · Hettinger, NDN1886AGriffith Richard B · Sycamore, IL
Back to AD 72-01-07