AD 2002-17-53
Registered aircraft · 6,266
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-17-53')
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-17-53')
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-17-53') 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-17-53') 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.
N121REHigh Life Aviation LLC · St George, UTN121SLLadet David E · Lavonia, GAN121SPFl280 LLC · Deland, FLN121TDelmarva Flight Leasing Inc · East Moriches, NYN121TFTorres Juan · Modesto, CAN121TWBlue Ridge Mountain Flyers Aviation LLC · Mineral Bluff, GAN121VBMt Aero LLC · Arundel, MEN1222ZFord Carol C Jr · Canyon Country, CAN1224TAig Aeronautics LLC · Guaynabo, PRN122AWAztec Worldwide Airlines Inc · Wilmington, DEN122JPZatika Francis · Bridgewater, NJN122MENorton Mark Trustee · Stateline, NVN122TEBouchillon James R · Hanahan, SCN1230BM&M Modal LLC · Denver, CON1232EVan Bortel Aircraft Inc · Arlington, TXN1232XGehrett Clifford Rooks · Sammamish, WAN123ALLambert Danny J · Plainview, TXN123BBSingletrack Aviation LLC · Brecksville, OHN123BEBald Moutain Aviators · Fredericktown, MON123GHMoyers Jeff · Troy, VAN123KCHelms Brandon M · Indian Trail, NCN123KW123 LLC · Allentown, PAN123LMMccleary Bryan W · Marion, OHN123PTScheller Erik G Trustee · Gig Harbor, WAN123PVSandlapper Aviation Of De Inc · Bennington, VTN123RMConstruction Imports LLC · Fleetwood, NCN123TEVirgil W Young Jr Pa · North Little Rock, ARN1243NZenisek Andrew F · Sioux Falls, SDN1247VSchwartz Mark S · Woodbury, NYN124AGPegasus Enterprises LLC · Granbury, TXN124EDSecond Wind Enterprises LLC · Chamblee, GAN124KYMozzie Air LLC · Tampa, FLN124WABraswell Jerrold W · Dillingham, AKN1258QSiner John R · Kingsport, TNN12595Cornell Terry Jason · Bloomsburg, PAN125AHPray Ricky Lee Trustee · Woodland Hills, UTN125AKBaize Equipment LLC · Crawford, TXN125SEDyer John F · Spring, TXN125WWRegistered aircraftN126CAFeltmann Dean A · North Charleston, SCN126DRForbis Michael · Calera, OKN126HJPeterson Charles William · Midway City, CAN126KMVan Bortel Aircraft Inc · Arlington, TXN126LMMatt Aviation Propertis Inc · Nashua, NHN126PCRoots & Wings Aviation LLC · West Simsbury, CTN126PKPtk Equipment Inc · Miami Lakes, FLN1275RHatter Dan D · Dumas, TXN127CBird Brian A · Duluth, MNN127GT7 Golf Tango LLC · Saint Petersburg, FLN127KHCentral Airlines Inc · Overland Park, KS
Back to AD 2002-17-53