AD 2002-07-01
Registered aircraft · 3,466
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-07-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:2002-07-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:2002-07-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:2002-07-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.
N8274QBravo Delta II LLC · Steamboat Springs, CON8275MValiair Limited Company Trustee · Casper, WYN8275QAbel Derek R · Rio Vista, CAN8277MBlalock Paul T · Longview, TXN827DGAfrica Inland Mission International Inc · Peachtree City, GAN827RPJireh Aviation LLC · Zeeland, MIN827TWGardner Thomas W · Lincoln, MEN8281Q9 North LLC · Parker, CON8281ZSpearfish Aviation Inc · Summerset, SDN8286M3 Jc LLC · Phoenix, AZN8287MProfessional Metal Services Inc · Albion, NEN8287QAdventist World Aviation · Wilson, NCN8288MAircraft Guaranty Corp Trustee · Oklahoma City, OKN828RJNielsen Ron E · Lindon, UTN8292MAircraft Guaranty Corp Trustee · Oklahoma City, OKN8293QBaker Marianne J · Raeford, NCN829BAAdaptive Resources Inc · Fort Morgan, CON82LWMuskox Ministries · Fairbanks, AKN8300QSafeco Leasing LLC · Port Alsworth, AKN831PRThomas Bruce A · Mount Juliet, TNN8334QVolatile Aero Ventures LLC · Boulder City, NVN833RTNash LLC · Carbondale, ILN8340QFly8ma LLC · Big Lake, AKN8345QKatahdin Air Service Inc · Hermon, MEN8352QUnited Indian Missions DBA · Tucson, AZN8355QDelta Pacific Northwest LLC · Anchorage, AKN8366QBesse Richard L · Wasilla, AKFirst renewal noticeN8368QBrown Christopher · Grass Valley, CAN8370QState Of Alaska Dept Of Fish And Game · Palmer, AKN8374Q8374q LLC · Gig Harbor, WAN8378QAeroworks Of Alaska LLC · Chugiak, AKN8386M213tz LLC · Hailey, IDN8386QLe Tourneau University · Longview, TXN8394QPacific Union College · Angwin, CAN8397QSeattle Seaplanes LLC · Seattle, WAN839HFFour Boys Flying LLC · Kalispell, MTN83BMShelton David B · Dallas, TXN83CEElsner Kelly J · Menahga, MNN8405QVan Pelt Matthew · Challis, IDN8409QFrey David G Jr · Grand Rapids, MIN841JLMarks Stephen M · Monument, CON841RQMueller Steven L · Osceola, WIN8424WExtra Equipment Inc · Stuart, FLN8439GSmith Air LLC · Cascade, IDN843YTTrue Drilling LLC · Casper, WYN8442QFerguson John W · Edwardsburg, MIN8451QRunway Three Aviation LLC · Kalispell, MTN8462QPahrump Aviation LLC · Las Vegas, NVN8463QSmith James M · Star, IDN8471QIgiugig Lodge LLC · Wasilla, AK
Back to AD 2002-07-01