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.
N111AJBergin Donald M · Ormond Beach, FLN111AKKershaw Andrew H · Spring, TXN111AZ360 LLC · Carson City, NVFirst renewal noticeN111BKBobs Super Cub LLC · Middleburg, FLN111CFGsm Tax & Insurance Inc · Naples, FLN111CKSouthard Brian K · Las Cruces, NMN111CPVelasco Ricardo Rene Jr · Cumming, GAN111DJLee Brian A · Riverdale, GAN111DLCresence LLC · Port Saint Lucie, FLN111DSStarflight Aviation Inc · Wilmington, DEN111DTInternational Air Services Inc Trustee · Carson City, NVN111DVSouthern Aircraft Consultancy Inc Trustee · Casper, WYN111DZDelta Hotel LLC · Griffin, GAFirst renewal noticeN111EWimpy Scott · Griffin, GAN111EMMccue Inc · Florence, MTN111EXNew Orleans Aviation LLC · Covington, LAN111FBMccarthy Elaine M · Indianapolis, INN111FCWoody Air LLC · Vero Beach, FLN111FFGutierrez Isaias · Fontana, CAN111FPPhoenix Carolina LLC · Saint Petersburg, FLN111GAGeorges Aviation Services Inc · Honolulu, HIN111GPVan Haitsma Kelley · Fort Worth, TXN111GWInternational Air Services Inc Trustee · Carson City, NVN111HHarvey Mushman LLC · Kalispell, MTN111HKSky Peace Aviation LLC · Springdale, ARN111HPFlying Aces Aero-Fleet Inc · Guyton, GAN111HYSch Aviation Inc Trustee · NorfolkN111KDWedekemper Steven E · Brighton, MIN111KTHolt Helicopters Inc · Uvalde, TXN111LAAmmons Curtis D · Hernando, MSN111LCOyster Chris R · Bellville, OHN111LESky Photoshop LLC · Winter Garden, FLN111LFZimmerman Leland · Center, CON111LRLo Jeffrey G · San Jose, CAN111LSGrant William S · Azle, TXN111LUSchaefer Robert Lee · Orange, CAN111MBTinder John A · Rancho Cucamonga, CAN111MEElliott Enterprises Group LLC · Wilmington, DEN111MJJohn D Chinchen Md Pa · Mountain Home, ARN111MPHowell Nicholas A · Englewood, CON111MVVodon Mark A · Ventura, CAN111MWSaratoga 181 LLC · Mesa, AZN111MYMeshed Networx LLC · New Market, VAN111NFNakonieczny David · The Colony, TXN111NPBlackfoot Aviation LLC · Bozeman, MTN111NWKnell LLC · Casper, WYN111PAWpp Nautical LLC · Helena, MTN111PBRegistered aircraftN111PKScruggs Ken · Galloway, OHN111PSAjeac Inc · Fairview, PA
Back to AD 2012-19-01