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.
N8990TPoulter Michael D · San Angelo, TXN8992GKing William · Tallulah, LAN8992UCole Lawrence E · Willow Street, PAN8992VFreeze Otis C · Frankston, TXN8993SRopp Dale Arden · Bemidji, MNN8993TCoughran Aviation LLC · Rio Vista, CAN8993VBmg Aviation Leasing LLC · Bloomington, INN8993WWagner Mitchell · Northlake, TXN8993XEvans David J · Parker, CON8994GRussmann Nicholas S · Merit, TXN8994SMorel Charles Paul IV · Morgan Hill, CAN8994TRollings Paul W · Anderson, SCN8994UWahlberg Randy A · Pearland, TXN8995BSommerfeld David A · Assaria, KSN8995SLonneman Robert P · Edgewood, KYN8995UKelley Aircraft LLC · Weyers Cave, VAN8995XHowards Hangar LLC · Peachtree City, GAN8996BGartrell Kirk W · Amarillo, TXN8996SSoaring Thunderbirds Inc · Canton, OHN8996TWedemeyer Bonnie J · Cheyenne, WYN8996VBaumgartner Scot W · Colby, WIN8996XRobertson Timothy A · Lewistown, MTN8997SRed Barn Ag & Home Inc · Westville, OKN8997VHusker-Hawkeye Distributing Inc DBA · Omaha, NEN8998BValles Rick James · Albuquerque, NMN8998THayhurst Jack R · League City, TXN8999BRacoon Aviation LLC · San Antonio, TXN8999GSouther Field Aviation Inc · Americus, GAFirst renewal noticeN8999SLewis Darrell K · Morehead, KYN899AAAoa Kissimmee Inc · Kissimmee, FLN899AHAerospace Asset Holdings LLC · Wilmington, DEN899CPCivil Air Patrol · Maxwell Afb, ALN899JHMickle Aviation Inc Trustee · Wilmington, DEN899JRAb Prop Plane II LLC · Metairie, LAN899MDLarson Aeromedical Services LLC · Salem, ORN899PPT&M Air Az LLC · Phoenix, AZN899RCOsprey Aviation LLC · Hamilton, MTN899SPPolyspray Corp · Asheboro, NCN89EPBas Part Sales LLC · Greeley, CON89HPMorgan Howard P Jr · Longmont, CON89JFWitt Roger S · Spencer, MAN89KAKenmore Air Harbor LLC · Kenmore, WAN89KPRegistered aircraftN89KSRoss Tim · Las Vegas, NVN89LUTextron Aviation Inc · Wichita, KSN89SFMiller Luke · Redmond, WAN89SJMountain Escape LLC · Pullman, WAN89WWAley Jeffrey S II · Granby, CON8APacific Aviation LLC · Cottage Grove, ORN8AARovey Land And Cattle Co Inc · Parker, AZ
Back to AD 79-10-14 R1