AD 2012-19-01
Registered aircraft · 51,501
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:2012-19-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-19-01')
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:2012-19-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-19-01') 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.
N102EASteves Atv Services Inc · Oceano, CAN102EXWoods Farrell T · Hudson, NHN102FMRegistered aircraftN102FVGruba Sheila M · Saint Joseph, MNN102JFAble Enterprise LLC · Tampa, FLN102JKRockstar Aviation LLC · Cresson, TXFirst renewal noticeN102JVWestern Michigan University · Battle Creek, MIN102KSKent State University · Stow, OHN102KTPoler Steven P · Olympia, WAN102LPWashington State Patrol · Olympia, WAN102MOk Av8r LLC · Iowa Park, TXN102MASquaw Creek Aviation LLC · Dover, DEN102MREquipment Services Corp · Wahpeton, NDN102PCBradley Max T Sr · West Plains, MON102PFKaehr Lyle · Decatur, INN102PMBrown Scot C · Las Vegas, NVN102RCJohnston Steve M · Lyle, WAN102RHHayes Ronald O · Blue Springs, MON102RRMoyer Aviation Ll C · Katy, TXN102RSSuttle Richard T Jr · Austin, TXN102SJHelms Robert J · Alton, UTN102TMJunior Fernando Sporleder · Sarasota, FLN102WHStuddiford James A · Lithia, FLN102WMStar Air Service LLC · Jacksonville, FLN102WZVcxi Red LLC · Sheridan, WYN10305Blunt Samuel N · Summerville, SCN1030NDcaw Aviation LLC · Advance, NCN1030ZLenhart Thomas E · Barnesville, GAN1031XJj Byrne International Inc · Steamboat Springs, CON10329Lissow William M · New Port Richey, FLN1032JKornegay Kenneth D · Roanoke, VAN1032SThurber Matthew Calbraith · Vancouver, WAN10339Yarbro Floyd A · Kenton, TNN1033AAtlas Aviation Tampa Inc · Tampa, FLN1033CHuson Lee E · Port Townsend, WAN1033TManzo Deborah S · Lake Placid, FLN1033YSouthern Aircraft Consultancy Inc Trustee · Casper, WYN1034XBlasa Randy · Bowling Green, FLN1035XSocal Blue Side Up LLC · Anaheim, CAN1036JPremier Jets Inc · Hillsboro, ORN1036LN1036l Corp · Wilmington, DEN1036MMangon Aircraft Inc · Petaluma, CAN1036NKovaleski Thomas J · Chugiak, AKN1036XMotley Douglas Trustee · Rehoboth Beach, DEN1037JTate Andrew E · Chapel Hill, NCN1038JLandgraf Robert J · Sussex, WIN1039JN1039j LLC · Casa Grande, AZN1039MManly James H · Reno, NVN1039PN1039p LLC · Suwanee, GAN1039UIowa Lakes Community College · Estherville, IA
Back to AD 2012-19-01