AD 97-06-06
Registered aircraft · 2,038
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:97-06-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-06-06')
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:97-06-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-06-06') 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.
N20FWUas Transervices Inc · Boca Raton, FLN20RADepartment Of The Air Force · Hill Afb, UTN20SA Paradise Repo LLC · Nokomis, FLN20WPMoser Aircraft Service LLC · Huntington, INN210ECState Of Tennessee · Nashville, TNN211CGAzul Air LLC · Dover, DEN211GLAlpine Aviation Inc · Provo, UTN211LGStaggerwing Holdings LLC · Englewood, CON211VPCentral Virginia Aviation Inc · North Dinwiddie, VAN212HCHcc Air LLC · Las Vegas, NVN212LWPf Aviation LLC · Carl Junction, MON213AVDodson International Parts Inc · Rantoul, KSN213DBMarshall Air Systems Inc · Charlotte, NCN213PHPyro Shows Equipment LLC · La Follette, TNN214GBPterodactyl Inc · Wilmington, DEN214PNavajo Nation · Window Rock, AZN214SBSan Bernardino Co Sherriffs Dept · San Bernardino, CAN214SCAzul Air LLC · Dover, DEN214TPPlatinum Aviation LLC · Monte Sereno, CAN215HCPlane Lease Co · Minneapolis, MNN216CSAlpine Aviation Inc · Provo, UTN217CMKlas-Kcoe LLC · Las Vegas, NVN217LGStaggerwing Holdings LLC · Crystal Lake, ILN217MLDodson Intl Parts Inc · Rantoul, KSN218DZRed Brick Summit LLC · Wilmington, DEN218GJJaztec LLC · Ooltewah, TNN218SLAlpine Aviation Inc · Provo, UTN2192LSiller Brothers Incorporated · Yuba City, CAN219JGInternational Jet Aviation Services Inc · Centennial, CON219RMMoro Aircraft Leasing Inc · Two Rivers, AKN219VPAlpine Aviation Inc · Provo, UTN219WWTj Air Holdings Inc Trustee · Wilmington, DEN21BDSouthern Illinois Helicopters LLC · Marion, ILN21CGN21cg Leasing LLC · Ponca City, OKN21DELocke-Lane Aviation LLC · Statesville, NCN21DZBravo Hotel LLC · Lewes, DEFirst renewal noticeN21FGCalifornia Department Of Fish And Game · Sacramento, CAN21FWUas Transervices Inc · Boca Raton, FLN21KGSuncrest Aviation LLC · Labelle, FLN21RZUas Transervices Inc · Boca Raton, FLN220GLAlpine Aviation Inc · Provo, UTN220KWAirselect LLC · West Point, IAN220RARoyal Air Freight Inc · Waterford, MIN220TTShannair LLC · Saint Louis, MON220VTExec III LLC · Maineville, OHN221BHUas Transervices Inc · Boca Raton, FLN222AGKryptonite Industries LLC · Golden, CON222CYBlue Star Gas Fleet Services Co · Santa Rosa, CAN222KCU S Army - Owner · New Century, KSN222LAGrb Logistics LLC · Grapevine, TX
Back to AD 97-06-06