AD 2007-01-06
Registered aircraft · 1,397
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:2007-01-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:2007-01-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:2007-01-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:2007-01-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.
N111BVOceanside Vertical Express LLC · Canaan, NYN111HFPlane Fun Inc Tr Trustee · Snellville, GAN111PMTri Rotor Spray And Chemical · Ulysses, KSN111SPState Of Michigan · Lansing, MIN112EPMarks Aviation Group LLC · Lafayette, LAN112LPRanger Aviation Leasing LLC · Wilmington, DEN113AEAir Evac Ems Inc · O Fallon, MON114SFN179sf LLC · Chandler, AZN1158BAir Gov 1 LLC · Rome, NYN1171Agricultural Air Services LLC · Jupiter, FLN117HKSettan Corp · Goleta, CAN118AEAir Evac Ems Inc · O Fallon, MON118FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLN118TVInterstate Helicopter Inc · Bethany, OKN119AEAir Evac Ems Inc · O Fallon, MON11FHD H Helicopter Inc DBA · Sauget, ILN11TVHelicopters Inc · Cahokia, ILN120LHHelilease LLC · Lewes, DEN1219WMoes Crop Dusting Service Inc · Marysville, CAN121BT206 Holdings LLC · Spanish Fork, UTN121LPPremier Rotors LLC · Saint Martinville, LAN122BTNorth Wind Aviation LLC · Cottage Grove, ORN122JLotus Aviation LLC · Boring, ORN123HPSouthwest Heliservices LLC · Mesa, AZN123NCNorth Carolina State Highway Patrol · Cary, NCN123RJR J Corman Railroad Co/Bardstown Line · Nicholasville, KYN123WFJk Aviation LLC · Kerman, CAN124AEAir Evac Ems Inc · O Fallon, MON125TAGm Leasing Company LLC · Broussard, LAN126SHKey West Helicopters LLC · Key West, FLN127APGm Leasing Co LLC · Broussard, LAN12AAAllsouth Aviation LLC · Buford, GAN12AEAir Evac Ems Inc · O Fallon, MON12ATCustom Cub LLC · Keizer, ORN12BQHelicopters Inc · Cahokia, ILN12EWJetcopters LLC · Lewes, DEN12JWRuffwood Inc · Atlanta, GAN130AEAir Evac Ems Inc · O Fallon, MON130BHObrien Helicopters Inc · Lehigh Acres, FLN130CCAirone Helicopters LLC · Slaughter, LAFirst renewal noticeN130JHRanger Aviation Leasing LLC · Wilmington, DEN131WMWestwind Helicopters Inc · Santa Fe, TXN132AEAir Evac Ems Inc · O Fallon, MON1337KJsg Aviation LLC · Wilmington, DEN133AEAir Evac Ems Inc · O Fallon, MON134AEAir Evac Ems Inc · O Fallon, MON134MSSunny Sky LLC · Stacyville, IAN1368XLinscott Jeffrey R · Boring, ORN136JSBettencourt Flg Svc Inc · Atwater, CAN136TWSilver Creek Aviation Services · Fort Worth, TX
Back to AD 2007-01-06