AD 75-06-01
Registered aircraft · 2,832
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:75-06-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:75-06-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:75-06-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:75-06-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.
N308CSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN308MDGem City Properties LLC · Laramie, WYN308RMN308rm LLC · Boca Raton, FLN3096PV V I P LLC · Cottonwood, AZN3098365 Whiskey Romeo LLC · Timnath, CON309CQFelicidad Holdings LLC · Winter Springs, FLN309LTLebeouf Bros Towing LLC · Bourg, LAN30BEEllingson Craig Edward Trustee · Clive, IAN30CCTalon Air Services Inc · Soldotna, AKN30EAEagle Air Transport Inc · Ottawa, ILN30HVCustom Fabricating & Repair Inc · Marshfield, WIN3104WBirch Tree Aviation LLC · Unadilla, GAN3104YCrop Dusters LLC · Maurice, IAN3105EJohnson Airspray Inc · Argyle, MNN31062Central Virginia Aviation Inc · Petersburg, VAN310JKConnors Air Holdings LLC · Tierra Verde, FLN3110TWellborn Aviation LLC · Texarkana, TXN3117SBlue Horseshoe LLC · Brentwood, TNN3117VP&C Aircraft LLC · Chapel Hill, NCN311GCRte Enterprises Inc · Canoga Park, CAN311KDTriple C Charters LLC · Carmel, INN311MXInternational Air Services Inc Trustee · Carson City, NVN312BCWorldwide Option LLC · Lewes, DEN312RLNyati Worldwide LLC · Sinton, TXN312SBSwitchback Aviation LLC · Roscoe, MTN313DWDurair Inc · Key West, FLN313HAValiair Lc Trustee · Casper, WYN314AWUS Government · Washington, DCN315AWUS Government · Washington, DCN315WSAircraft Guaranty Corp Trustee · Oklahoma City, OKN3160XWoodley Aerial Leasing LLC · Walnut, ILN316LVBayne Air LLC · Whitefish, MTN316PDLonghorn Air LLC · Wilmington, DEN316PMAir Methods LLC · Greenwood Village, CON316PWAl Force 1 LLC · North Salt Lake, UTN316WRHoxie Sprayers Inc · Hoxie, KSN317XTN317xt LLC · Henderson, NVN31941Gasper Air Spray Inc · Crookston, MNN319EEReveille Aviation LLC · Kurten, TXN319PDOrtiz Luis Emerito Nieves · Plantersville, TXN319TBShuck Holdings LLC · Anderson, SCN319WWWin Win Aviation Inc · Wake Forest, NCN31JA100-042 LLC · Menlo Park, CAN31TNLake Clark Air Inc · Port Alsworth, AKN31WDWestern Dakota Holding Co · Timber Lake, SDN31XXTj Air Holdings Inc Trustee · Wilmington, DEN320N320 LLC · North Las Vegas, NVN320KTRustair Inc · Anchorage, AKN321N321 LLC · North Las Vegas, NVN3211RJohnson Airspray Inc · Argyle, MN
Back to AD 75-06-01