AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N182DPCopeland Aviation LLC · Cedar Park, TXN182ESwanson Jorge A · Douglas, AZN182EB182 Flyers LLC · Spartanburg, SCN182EGBurnette Ric · Sebastian, FLN182FBDownwind Abeam Inc · Pasadena, CAN182FNSumner Investments LLC · Denham Springs, LAN182FRRedwood Airport LLC · River Ridge, LAN182GFGormley Lane Martin · Stanwood, WAN182GHTroy-Oakland Pilots Flying Club Inc · Troy, MIN182GMBaker Charles W · Lake Worth, FLN182GNWorthington Greg · San Francisco, CAN182GZAircraft By Farkas LLC · Middleburg Heights, OHN182HATurner Company LLC · Hearne, TXN182HCDrake Craig C · Brandon, MSN182HFCook Daniel E · Gulf Breeze, FLN182HZElings Heath R · Conrad, MTN182JDRegistered aircraftN182JSJohn W Spurlock Md Ltd · Bethlehem, PAN182JZMercer Fraser Co · Eureka, CAFirst renewal noticeN182KCBas Part Sales LLC · Greeley, CON182KGKeefe Patrick M · Watersmeet, MIN182KHDowning Billy G · Imboden, ARN182KSAltivor LLC Trustee · Sheridan, WYN182LKEllison William G · Telluride, CON182LMCommercial Diving Inc · Melbourne, FLN182MASterling Flight Training LLC · Jacksonville, FLN182MGTurnidge Austin Michael · Seattle, WAN182MJNelson Theresa H · Knoxville, TNN182MUTru Flight Materials LLC · Wilmington, DEN182NCKrizauskas David F · Moncks Corner, SCN182NWNorthwestern Michigan College · Traverse City, MIN182PJHarris William · Bullard, TXN182PMRg Aviation LLC · Fulton, MSN182PPPatch Patricia A Trustee · Titusville, FLN182RHFinnelly Patrick J · Hunts Point, WAN182RNNensel Richard E · Sylvania, OHN182RRDont Be Nosy LLC · Fresno, CAN182SHColes Robert John Jr · Santa Barbara, CAN182SPT Mark Fay Consulting Inc · Naperville, ILN182SVSky-Vu Flyers Inc · Fishers, INN182TPepper Gregory Lee · Fayetteville, GAN182TAJeppesen Employees Flying Assiciation Inc · Englewood, CON182TSLynch Larry E · West Branch, IAN182UKarl Mark G · Wilbraham, MAN182VBNemirsky Nicholas · Huntington Beach, CAN182VMBergey-Shisler Joanna · Chalfont, PAN182VPJobsight Delta Inc · Sugar Grove, ILN182VTStarbros Aviation LLC · Southlake, TXN182WDLewis W D III · San Carlos, CAN182WGBurgett Dale · Lake Lure, NC
Back to AD 2006-10-21