AD 83-15-07 R1
Registered aircraft · 133
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:83-15-07-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:83-15-07-R1')
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:83-15-07-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:83-15-07-R1') 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.
N100WRBuehler Andrew · Eatonville, WAN1115FSilverhawk Aviation Academy LLC · Caldwell, IDN121SESpitzer Helicopter LLC · Woodland Hills, CAN12424Helicopter Academy Com LLC · Rehoboth Beach, DEN12699Helicopteracademy.Com LLC · Rehoboth Beach, DEN12715Helicopteracademy.Com LLC · Rehoboth Beach, DEN12896Helicopteracademy.Com LLC · Rehoboth Beach, DEN12BVRoberts William O · Lexington, VAN139AGSchool Board Of Seminole Co Florida · Sanford, FLN143SHSpitzer Helicopter LLC · Woodland Hills, CAN153SHSpitzer Helicopter LLC · Woodland Hills, CAN154SHSpitzer Helicopter LLC · Woodland Hills, CAN155SHSpitzer Helicopter LLC · Woodland Hills, CAN156SHSpitzer Helicopter LLC · Woodland Hills, CAN157SHDuberman Eric David · Sanford, NCN158SHSpitzer Helicopter LLC · Woodland Hills, CAN165JCSmoketown Helicopters LLC · Smoketown, PAN166DKBranscum Jill Kubecka · Edna, TXN186SHContinental Helicopters Inc · Sheffield, TXN19MESims Hollon M · Lithonia, GAN19UPRs Aviation Services · Moorpark, CAN2225CCashwell Kenneth E · The Villages, FLN223VAVeracity Aviation LLC · Seguin, TXN224LJJets To Helis LLC DBA · Chandler, AZN225KYAtb Inc Trustee · Wilmington, DEN227WM227wm Aircraft Leasing LLC · Spanish Fork, UTN22JDGebo Christopher T · Hubbardston, MAN231TMCasablanca Helicopter LLC · Rehoboth Beach, DEN234RWAnthelion Helicopters · Long Beach, CAN251BDWheatly Andy · Hedley, TXN254SRJets To Helis LLC DBA · Chandler, AZN2604LE W Eaken & Co LLC · Columbiana, OHN26VHWise Joe · Kilgore, TXN26WHHall Wendell W · Cheraw, SCN292BAPic LLC · Catano, PRN301RWRegistered aircraftN301SHSpitzer Helicopter LLC · Wilmington, DEN30CHSale Reported · Maiden, NCSale reported, pending cancellationN315JFFuller Jon A · Goliad, TXN32ADRobinson Helicopter Co · Torrance, CAN32VGRegistered aircraftN341MKAlba Aviation Services Inc · Scottsdale, AZN345UHUhi Inc · Provo, UTN364MNakamura Hajime Trustee · Long Beach, CAN403CPGreenblatt Steven · Macon, GAN410TTWerhan Alan · Rockford, WAN412TLDelta Leasing Inc DBA · Chandler, AZN421HKHotel Kilo Holdings LLC · Laguna Beach, CAN424SFJets To Helis LLC DBA · Chandler, AZN436SKTds Property Holdings LLC · Gilmer, TX
Back to AD 83-15-07 R1