AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N6943SBoniek Martin J · Nederland, CON6943XSkinner Roma L · Ovilla, TXN6944EHinds Archie L · Claremore, OKN6944RSilcox Cleven L · Sapulpa, OKN6944SVfr Aviation LLC · Clayton, NYN6945EFiltration & Separation Technologies Inc · Glen Ellyn, ILN6945RDonham William David · Odessa, TXN6945XA Team Motors LLC DBA · Henderson, NVN6946CRegistration Pending · Fairbanks, AKRegistration pending, canceledN6946F46fox Aviation LLC · Bedminster, NJN6946RGrosslight Gordon · Westcliffe, CON6946SImage Aviation Services LLC · Wilmington, DEN6947EFirestone Bradley W · Colville, WAN6947GLin-Aero LLC · Conway, ARN6948ASelf David J · Wagener, SCN6948ESchrader Leif · Myrtle Point, ORN6948FLee Ethan · Millsap, TXN6948GJbar Ranch LLC · Downey, IDN6948SZaremba Michael W · Custer, WIN6948XWalburg Frank L · Zanesville, OHN6949EFoster David B · Athens, TNN6949FConaway Byron Richard · Savannah, TNN6949GTillstrom Gary A · Memphis, TNN6949RElyan Aviation Inc · Palm Springs, CAN694BKBell Bruce · Desert Aire, WAN694CPCivil Air Patrol · Maxwell Afb, ALN694MDBice Eric L · Renton, WAN694MMBrown Ryan W · Nampa, IDN694QPhillips Todd · New Albany, MSN694SAMile High Ventures Inc · Palm Harbor, FLN694SCAlpha Charlie Aviation LLC · Oregon City, ORN694SMSurveying And Mapping LLC · Austin, TXN694SPFox Leasing Group LLC · Hollywood, FLN694TCBruton Aerial Spraying Inc · Garden City, TXN6950AGallagher David R · Auburndale, FLN6950EMahler Jacson B · Reno, NVN6950FRgv Flight Academy LLC · Bayview, TXN6950XAnderson Thomas R · Seattle, WAN6951GHernandez Alfonso · Garland, TXN6951MDavid Paul T · Santa Barbara, CAN6952ABig Sky Adventures LLC · Nicholasville, KYN6952EBeauchamp James W · Butte, MTN6952FSkalsky Nathan · Tigard, ORN6952SMyers Karen J · Bemidji, MNN6953GVidal Miguel · Novi, MIN6953MN6953m Kemt Aircraft LLC · Monrovia, CAN6954ALindroth Richard J · Eleanor, WVN6954EBaylis Thomas B · Hattiesburg, MSN6954FRegistration Pending · Sumner, WARegistration pendingN6954SPierson Jared · Coeur D Alene, ID
Back to AD 79-10-14 R1