AD 97-01-13
Registered aircraft · 54,837
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N181UKauffman Daniel C · Spring Grove, PAN181VVScriva Jennifer L · Sherwood, ARN181XLHis Wings Air Service Inc · Hyder, AKN18200Morristown Flying Service Inc · Talbott, TNN18201Anderson William T · Pine Bluff, ARN18202Flying Tomato Aviation LLC · Medina, OHN18208Ivy James E · Alba, TXN1820KBergstrom Aircraft Inc · Pasco, WAN1820RBarkhimer James C · Iraan, TXN1820VAsp Kenneth · Thief River Falls, MNN1820ZStaats Douglas E · Anchorage, AKN18210Aircraft Construction Specialist Inc · Collinsville, OKN18213Diek Mondo R · Stevenson, WAN18218All Spark Aviation LLC · Naples, FLN1821FAlexander Travis · Hudson Oaks, TXN1821QPamperien Casey Dean · Manassa, CON1821RHoward Todd R · Minneapolis, MNN1821SBailey Ralph E · Sikeston, MON1821XCluer Brian L · Bodega, CAN1821YKinney James R · Vermillion, SDN18222Baxter Paul A · Logandale, NVN18225Cosentino Allen P · Templeton, MAN18226Filler Joseph J · Wyoming, PAN18229Fluno John I · San Anselmo, CAN1822CBrouwer Aviation LLC · Kalamazoo, MIN1822QPopiol Victor · Doral, FLN1822ROney Tony K · Anchorage, AKN1822ZAhrens Kevin Michael · Cashmere, WAN18233Geiger Kurtis · Visalia, CAN18234Nance David B · Quinton, VAN1823AKearns Adam · Portland, ORN1823RJones Alfred J · Friendsville, PAN1823XN1823x LLC · Middletown, DEN1824Luvara Michael S · San Jose, CAN1824AVesper David G · Ashland, OHN1824GHarkness Michael D · San Luis Obispo, CAN1824MHeinke Nils A · Elkins, WVN1824RKleissas Constantine · Wye Mills, MDN18256Registered aircraftN1825QCree William H III · Long Beach, CAN1825RKincaid James B · Wasilla, AKN1825YRound Engine Aero · Nashville, MIN1825ZGreentek Inc · Oroville, CAN18266Underwood Gary · Lewisville, TXN1826QMiller Brent R · Orefield, PAN1826YSwensen James A · Lake Point, UTN1827XFlatland Farms LLC · Hooker, OKN1828FDrew Kevin · Fredonia, PAN1828YPaulk Tracy · Fitzgerald, GAN1828ZHorrocks Charles M · Blackfoot, ID
Back to AD 97-01-13