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.
N4870GCal Aggie Flying Farmers Inc · Davis, CAN4871FFry Robert S Jr · Poplar Grove, ILN4871VBt Aero Precission Flight Accademy LLC · Oakdale, CAN4872DPs N4872d LLC · Green Bay, WIN4872UBushwackers Leasing LLC · Calera, OKN4873DRagan Matthew T · Boulder City, NVN4873G4873g Flying Club Inc · Punxsutawney, PAN4874QSutton Aircraft Salvage LLC · Palmer, AKN4876DAcute Holdings LLC · Jenks, OKN4876FCosta Air Service LLC · Painted Post, NYN4876GKing Bryan A · Austin, TXN4876UCottrell Seth M · Kenai, AKN4876YCarson Engineering And Manufacturing Inc · Springdale, ARN4877DAviator Air Flight School LLC · Grand Prairie, TXN4877JR&R Aero Services LLC · Eden Prairie, MNN4878DCache La Poudre LLC · Fairfield Bay, ARN4878FNistler Gabriel R · Helena, MTN4878QRichter Patrick A · Edna Bay, AKN4878Y182b LLC · La Plata, NMN4879DMorey Airplane Company Inc · Middleton, WIN4879FCitizen Air LLC · Port Angeles, WAN487ERCloudchasers LLC · Colorado Springs, CON487MTGilmore Bobby Keith · Swifton, ARN487SPArchimedes Aviation LLC · Livermore, CAN487XACrafa Steven J · Golden, CON4880DBernstein Timothy D · Faith, SDN4880FFkm Air Shuttle LLC · Brooklyn, NYN4880GCifelli George J · Dothan, ALFirst renewal noticeN4880NFront Porch Air LLC · Dalton, GAN4880UYanikoski Joseph A · Stoughton, MAN4881DBurt Compton Enterprises Inc · Marfa, TXN4881EFulltron Aviation LLC · Springfield, MON4881QAir Dakota Flite Inc. · Hettinger, NDN4881U270 W Pearl LLC · Jackson, WYN4882NCreative Strategies Inc · Proctorville, OHN4883DKingdom Air Corps · Sutton, AKN4883FStillinger David C · Cardiff By The Sea, CAN4883GPlane Nuts Aviation LLC · Livingston, LAN4884DGarcia Robert · Arcadia, CAN4884NCure Louie M · Granbury, TXN4885DSpartan National Holdings LLC · Missoula, MTN4885GS&P Aviation LLC · Albuquerque, NMN4885XEggleston Kevin M · Moore, OKN4886DRegistered aircraftN4886GSkycrafters Inc · Johnson City, TNFirst renewal noticeN4886NMartin Barry W Trustee · San Diego, CAN4886USkycase Leasing LLC · Wasilla, AKN4887Carroll Daniel G · Magnolia, TXN4887DShank Lawrence · Pagosa Springs, CON4887GSouthern Aero LLC · Homestead, FL
Back to AD 79-10-14 R1