AD 2002-19-03
Registered aircraft · 12,723
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:2002-19-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-19-03')
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:2002-19-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-19-03') 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.
N10PJMiller Kenneth R · Russellville, KYN10PZPaxton Aviation Inc · Wilmington, DEN10QBAsc Aviation LLC · Brandon, MSN10QHComanche Maverick Air LLC · Houston, TXN10UPLeonards Dream LLC · Kent, OHN10YCToyz Aviation LLC · Worthington, KYN10YRAj Aviation LLC · Colby, KSN10ZVThat 70s Plane Inc · Athens, GAN1102NWorld Class Athletic Surfaces Inc · Leland, MSN1105Staley William J Jr · Medford, NJN1105XGay Faith E · Johnstown, NYN1107RBrewer David W · Savannah, TNN110AVCarter Jay W Jr · Wichita Falls, TXN110CRJaffe Richard A · Westport, CTN110GCAltitude Ventures LLC · Lexington, NCN110GSGcb LLC · Kalispell, MTN110HHParker Rhoderick A · Colonial Beach, VAN110LVRv Transition LLC · Columbia Falls, MTN110MRKertz Ryan E · Sonoma, CAN110SCClark Steven D · Bloomfield, INN110STBright Dale A · Limestone, TNN110SXSkyryse Inc · El Segundo, CAN110UDarnell Charlie · Eads, TNN110WBFerrin Aviation LLC · Rome, GAN110WRRuffo-Silva LLC · Wilmington, DEN110WTW T Aviation LLC · Wichita, KSN110XPGreenstreet Scott · Poplar Grove, ILN11111Star Flight LLC · Bellevue, WAN1111KBlue Monkey Disposing & Recycling Inc · Tampa, FLN1111MRw Air LLC · Rock Hill, SCN1117PD W Shimoda LLC · Itasca, ILN111AKKershaw Andrew H · Spring, TXN111CFGsm Tax & Insurance Inc · Naples, FLN111CKSouthard Brian K · Las Cruces, NMN111DLCresence LLC · Port Saint Lucie, FLN111DSStarflight Aviation Inc · Wilmington, DEN111DVSouthern Aircraft Consultancy Inc Trustee · Casper, WYN111DZDelta Hotel LLC · Griffin, GAFirst renewal noticeN111EWimpy Scott · Griffin, GAN111GAGeorges Aviation Services Inc · Honolulu, HIN111HKSky Peace Aviation LLC · Springdale, ARN111HYSch Aviation Inc Trustee · NorfolkN111KDWedekemper Steven E · Brighton, MIN111LCOyster Chris R · Bellville, OHN111LFZimmerman Leland · Center, CON111MEElliott Enterprises Group LLC · Wilmington, DEN111MWSaratoga 181 LLC · Mesa, AZN111MYMeshed Networx LLC · New Market, VAN111NWKnell LLC · Casper, WYN111PAWpp Nautical LLC · Helena, MT
Back to AD 2002-19-03