AD 2005-10-13
Registered aircraft · 1,224
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:2005-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-10-13')
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:2005-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-10-13') 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.
N762LCLeon County Sheriffs Office · Tallahassee, FLN762SHBlue Air Training Corp · Las Vegas, NVN76431Four Creeks Aviation Inc · Visalia, CAN7650MAnw Investment Group LLC · Denham Springs, LAN76544Churchill Scott · Jordan, MNN765BWHva Inc · Summersville, WVN765KVWinco Inc · Aurora, ORN769KBWhiskey River Aviation LLC · Medford, ORN76TLJ L Smith Enterprises LLC · Jackson, KYN770FKInternational Air Services Inc Trustee · Carson City, NVN770HPDodson International Parts Inc · Rantoul, KSN771KESchilling Michael K · Kenai, AKN772DWCcf Ventures Inc · Bangor, MEN774CBCbhelos LLC · Chesapeake, VAN775BDAviation Advantage Inc · Tabor City, NCN775DWCosta James J · Prineville, ORN77766Usda Aphis Wildlife Services · Cedar City, UTN779DWRegistered aircraftN77DCOmega 377 Pennsylvania LLC · Shavertown, PAN77YVSara Helicopters Inc · Wilmington, DEN782MHRotor Blade LLC · Pawleys Island, SCN784FNascar Aviation LLC · Silverado, CAN785CBHarr Jeremy E · Kingsport, TNN7860SMagnum Aviation LLC · Goff, KSN78906King County Sheriffs Office · Seattle, WAN78AMBell206 LLC · Anchorage, AKN78BRMontana Air Tankers LLC · Three Forks, MTN78MEElliott Enterprises Group LLC · Wilmington, DEN78NLH&G Farms Inc · Corcoran, CAN79987Usda Aphis Ws · Cedar City, UTN79FSMarchetti LLC · Conner, MTN7MTCsc Delaware Trust Co Trustee · Wilmington, DEN7UMSabe Aviation Inc · Santa Monica, CAN800JBHelicopter Applicators LLC · Pembroke, NHN800PHTomlinson Aviation Inc · Ormond Beach, FLN801JBNewwest LLC · Pembroke, NHN801SBBank Of Utah Trustee · Salt Lake City, UTN803JBGuardian Aero LLC · Flora, ILN804LASouthern Helicopter Inc · O Brien, FLN80558Oh58 Airborne LLC · Saint Petersburg, FLN805MDIntegrity Aircaft Title Holdings LLC · Portland, ORN806LACoastal Helicopters Inc · Panama City, FLN808BHNorton Basin Services · Nome, AKN808JHTreeline Helicopters Inc · Bristol, TNN808QPalmer Carroll W · Harper, ORN809WAWindward Aviation Inc · Puunene, HIN811WAWindward Aviation Inc · Puunene, HIN813RRIndian River County Sheriffs Office · Vero Beach, FLN81519Bell Textron Inc · Fort Worth, TXN8159JForming Agrotors Inc · Louisville, MS
Back to AD 2005-10-13