AD 2012-10-13
Registered aircraft · 13,306
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-10-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:2012-10-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:2012-10-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:2012-10-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.
N4925KAlberts Nelson · Weatherford, TXN4927N774pt Inc Trustee · Wilmington, DEN492CPCirrus Velocity Group LLC · San Antonio, TXN492DMDunaway Brian Scott · Perry, GAN492DPToepfer Arthur David · Boerne, TXN492DZN492dz LLC · Highland, UTN492MMJustarep Group LLC · Deerfield Beach, FLN4930VCirrusly LLC · Bonney Lake, WAN4937JSwirsding David J · Chalfont, PAN4939YDavidson Dan F · Ozona, TXN493CDCocozzoli Kevin A · Crestview, FLN493MSHingley Daniel · Boise, IDN493TRAircraft Guaranty Corp Trustee · Oklahoma City, OKN4940KGoves Abram M · Parker, CON4945MMidland College · Midland, TXN4946KOrion Technology Group LLC · San Diego, CAN4948AKeystone Aerial Surveys Inc · Philadelphia, PAN4949ASw Air LLC · Denver, CON4949SSchwenk Holdings LLC · Fort Myers, FLN494SRSolaero LLC · Toledo, OHN494TSDeep Creek Lake Ventures LLC · Oakland, MDN495495htsi LLC · Wilmington, DEN4950UAerotech Mapping Inc · Las Vegas, NVN4951YH & B Aeronautics LLC · Miamisburg, OHN4957ZGuinasso Kimberly Marsh · Reno, NVN4959CDoll House Properties Inc · Chesapeake, VAN495BCR&B Adventures LLC · Benton, KSN495CCM2 Aero LLC · Powell, OHN495CDJl Aviation LLC · Crestwood, KYN495CPIris Fliers Inc · Fernandina Beach, FLN495PDAbaco Aviation LLC · Bismarck, NDN495RDCapital Holdings 226 LLC · Naples, FLN495RMNorth Fork Wings LLC · Bakersfield, CAN495SCOptimum Aviation LLC · Sterling, VAN495SLAlair Scott C · Pleasanton, CAN4960JPonderosa Airtankers LLC · Safford, AZN4960KShuck Drilling Co · Edgar, NEN4967KBrown Lawson M II DBA · San Diego, CAN496ALDelta Lima LLC · Nashville, TNN496CDCirrus Skies LLC · Clayton, MON496CJPurview LLC · Brownsburg, INN496CPSportmed Outreach Air LLC · Gulf Breeze, FLN496DEHegedus Bruce Alan · Anchorage, AKN496GRRegistered aircraftN496LLLucky 28 Holdings LLC · Destin, FLN4971Osborne Scott M · Fort Myers, FLN4978UKempf Rodney G · Eugene, ORN497BCBarnes William · Hagerstown, MDN497CPGulfstream Turbine LLC · Naples, FLN497EBFl Scapes Inc · Panama City Beach, FL
Back to AD 2012-10-13